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.

Parameters

  • principal

    An optional user or group for which to show the privileges granted or denied. If not specified SHOW will return privileges for all principals who have privileges on the object.

  • securable_object

    The object whose privileges to show.

Example 

> SHOW GRANTS `alf@melmak.et` ON SCHEMA my_schema;
  principal     prvilege
  ------------- --------
  alf@melmak.et USE

> SHOW GRANTS ON SHARE some_share;
  recipient privilege
  --------- ---------
  A_Corp    SELECT
  B.com     SELECT