SHOW GRANT (SQL Analytics)

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

To run this command you must be either:

  • A SQL Analytics 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>