Show Grants


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.


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