SHOW AUTHORITY RULE 语法用于查询权限规则配置。
ShowAuthorityRule ::=
'SHOW' 'AUTHORITY' 'RULE'
| 列 | 说明 |
|---|---|
| users | 用户 |
| provider | 权限提供者类型 |
| props | 权限参数 |
SHOW AUTHORITY RULE;
mysql> SHOW AUTHORITY RULE;
+--------------------+---------------+-------+
| users | provider | props |
+--------------------+---------------+-------+
| root@%; sharding@% | ALL_PERMITTED | |
+--------------------+---------------+-------+
1 row in set (0.07 sec)
SHOW、AUTHORITY、RULE