SHOW GRANTS Statement

Description

The SHOW GRANT statement displays the permissions associated with the database user accounts.

Syntax

SHOW GRANTS FOR 'user'

Example

CREATE TABLE testgrant (id int);

CREATE USER user1;

GRANT INSERT,SELECT ON testgrant TO user1;

 

SHOW GRANTS FOR user1;

  Grants for USER1

======================

  'GRANT INSERT, SELECT ON testgrant TO USER1'