SHOW GRANTS (Databricks SQL)
Displays all privileges (inherited, denied, and granted) that affect the securable object.
To run this command you must be either:
A workspace administrator or the owner of the object.
The user specified in
principal
.
Use SHOW GRANTS TO RECIPIENT to list which shares a recipient has access to.
Syntax
SHOW GRANTS [ principal ] ON securable_object
You can also use GRANT
as an alternative for GRANTS
.