Show Grants

Important

This documentation has been retired and might not be updated. The product, service, or technology mentioned in this content is 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>