Show grants command in Snowflake

To Nha Notes | July 26, 2022, 1:43 p.m.

SHOW GRANTS

SHOW GRANTS ON ACCOUNT

SHOW GRANTS ON <object_type> <object_name>

SHOW GRANTS TO { ROLE <role_name> | USER <user_name> | SHARE <share_name> }

SHOW GRANTS OF ROLE <role_name>

SHOW GRANTS OF SHARE <share_name>

SHOW FUTURE GRANTS IN SCHEMA { <schema_name> }

SHOW FUTURE GRANTS IN DATABASE { <database_name> }
References

https://docs.snowflake.com/en/sql-reference/sql/show-grants.html

https://roboquery.com/app/syntax-show-grants-command-snowflake