SHOW GRANTS output consistency improvement (Pending)¶

When you run SHOW GRANTS and a database role or share is the grantee, or the granted_on column reports a general object type, Snowflake now returns a more consistent output. Share and database role names no longer include a name prefix, and the granted_on column reports the specific object type. Previously, these values weren’t consistent across the different forms of the command.

Before the change:

The output of SHOW GRANTS was inconsistent in two ways:

• Share and database role names in the grantee_name column sometimes included a name prefix and sometimes didn’t, depending on the form of the command.
• The granted_on column sometimes reported a general object type, such as TABLE, instead of the specific type of the object, such as VIEW.

After the change:

The output of SHOW GRANTS is consistent:

• Share and database role names in the grantee_name column never include a name prefix.
• The granted_on column always reports the specific object type, such as VIEW instead of TABLE.

This change is being made to unify the output of the SHOW GRANTS command across the different forms of the command.

How to update your code¶

If you have scripts or automation that parse the output of SHOW GRANTS, review how they handle the grantee_name and granted_on columns. Update any code that expects prefixed share or database role names in grantee_name, or that matches on general granted_on types, so that it works with the unprefixed names and the specific object types returned after the change.

Ref: 2371