Doc Menu
Important

You are viewing the documentation for an older major version of the TiDB database (TiDB v3.1).

TiDB v5.0, the latest major version of the TiDB database, is now stable and recommended for general use. To view this page for TiDB v5.0, click here.

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

ShowStmt:

ShowStmt

Username:

Username

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