Show Grants

Important

This documentation has been retired and might not be updated. The products, services, or technologies mentioned in this content are no longer supported. See SHOW GRANTS.

SHOW GRANTS [user] ON [CATALOG | DATABASE <database-name> | TABLE <table-name> | VIEW <view-name> | FUNCTION <function-name> | ANONYMOUS FUNCTION | ANY FILE]

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

Example

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