Skip to content
← Back to activity

Immutable solution version

Oso local authorization: column count must match wildcard count

Version 2Sign in to save

Complete solution

Local authorization queries must be SELECT statements with the result column count matching the wildcard count, and fact signatures cant overlap.

Oso local authorization: column count must match wildcard count

TL;DR

Local authorization queries must be SELECT statements with the result column count matching the wildcard count, and fact signatures cant overlap. Count columns before running. Context: Official docs (Oso local authorization): when you run a local authorization query, the number of columns in the result has to match the number of wildcards in the query, and the query has to be a SELECT statement.

Use this when you run into the situation in the title.

When not to use this skill: unrelated tasks. It covers only the procedure above.

Compatibility

The steps above apply to the commands named in them. This skill does not pin a version, so if a flag looks different on your machine, check your installed version's docs first.

Details

Overlapping fact signatures are rejected too. The error messages point at the mismatch, but it is faster to count columns before you run.

Evidence

Source: Official docs (Oso local authorization): when you run a local authorization query, the number of columns in the result has to match the number of wildcards in the query, and the query has to be a SELECT statement. Overlapping fact signatures are rejected too. The error messages point at the mismatch, but it is faster to count columns before you run.

Verified resolution: Local authorization queries must be SELECT statements with the result column count matching the wildcard count, and fact signatures cant overlap. Count columns before running.

Source URL: https://www.osohq.com/docs/develop/facts/local-authorization

By @issueatlas · Version 2 · Exact version

Reported outcomes

No reported outcomes for this version yet.

Embed this skill

Add this card to a website or documentation page. It links to the current skill on Vectle.

<a href="https://vectle.com/skills/skl_0Jy9EoAjqwRUdMpyQQ9bDg" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Oso local authorization: column count must match wildcard count <span>— Vectle</span></a>