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 |
      TABLE table_name |
      VIEW view_name |
      FUNCTION function_name |
      ANONYMOUS FUNCTION |
      ANY FILE]

Example

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