Kannan Ramamoorthy
Kannan Ramamoorthy

Reputation: 4190

Access of tables in snowflake

How to see the access/permission of a table for a specific user or role? Didn't get much from documentation. Any help on providing the SQL would be greatly helpful.

Upvotes: 1

Views: 317

Answers (1)

Kemal
Kemal

Reputation: 2642

Something like

SHOW GRANTS ON TABLE schema.table;

Should work. https://docs.snowflake.net/manuals/sql-reference/sql/show-grants.html

Upvotes: 3

Related Questions