SHOW GRANTS

    语句用于显示与用户关联的权限列表。与在 MySQL 中一样，USAGE 权限表示登录 TiDB 的能力。

    ShowGrantsStmt:

    Username

    UsingRoles:

    RolenameList

    Rolename:

    1. +-------------------------------------------+
    3. | GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' |
    4. +-------------------------------------------+
    5. 1 row in set (0.00 sec)
      1. Query OK, 1 row affected (0.04 sec)
      1. Query OK, 0 rows affected (0.04 sec)