SHOW GRANTS
This statement shows a list of privileges associated with a user. As in MySQL, the USAGE
privileges denotes the ability to login to TiDB.
Synopsis
ShowGrantsStmt:
Username:
UsingRoles:
RolenameList:
Rolename:
Examples
mysql> SHOW GRANTS;
+-------------------------------------------+
| Grants for User |
+-------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' |
+-------------------------------------------+
1 row in set (0.00 sec)
mysql> SHOW GRANTS FOR 'u1';
ERROR 1141 (42000): There is no such grant defined for user 'u1' on host '%'
mysql> CREATE USER u1;
Query OK, 1 row affected (0.04 sec)
mysql> GRANT SELECT ON test.* TO u1;
Query OK, 0 rows affected (0.04 sec)
mysql> SHOW GRANTS FOR u1;
+------------------------------------+
| Grants for u1@% |
+------------------------------------+
| GRANT USAGE ON *.* TO 'u1'@'%' |
| GRANT Select ON test.* TO 'u1'@'%' |
+------------------------------------+
2 rows in set (0.00 sec)
MySQL compatibility
This statement is understood to be fully compatible with MySQL. Any compatibility differences should be reported via an issue on GitHub.
See also
Was this page helpful?