📣

TiDB Cloud Serverless 现已更名为
Starter
!此页面由 AI 自动翻译,英文原文请见
此处。

SHOW GRANTS

此语句显示与某个用户相关联的权限列表。与 MySQL 一样,USAGE 权限表示登录 TiDB 的能力。

概要

ShowGrantsStmt
SHOWGRANTSFORUsernameUSINGRolenameList
Username
CURRENT_USER()Username@Hostname
RolenameList
Rolename@Hostname,Rolename@Hostname

示例

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 兼容性

TiDB 中的 SHOW GRANTS 语句与 MySQL 完全兼容。如果你发现任何兼容性差异,请报告一个 bug

相关链接

文档内容是否有帮助?