SHOW GRANT (Databricks SQL)

Displays all privileges (inherited, denied, and granted) that affect the specified object.

To run this command you must be either:

  • A Databricks SQL administrator or the owner of the object.
  • The user specified in user.

Syntax

SHOW GRANT [user]
  ON { CATALOG |
       DATABASE database_name |
       FUNCTION function_name |
       TABLE table_name |
       VIEW view_name |
       ANONYMOUS FUNCTION |
       ANY FILE }

Example

> SHOW GRANT `<user>@<domain-name>` ON DATABASE <database-name>