Retro Eye care Haitian Deep Dark Default

SHOW AUTHORITY RULE

Description

The SHOW AUTHORITY RULE syntax is used to query authority rule configuration.

Syntax

ShowAuthorityRule ::=
  'SHOW' 'AUTHORITY' 'RULE'

Return Value Description

Column Description
users users
provider privilege provider type
props privilege properties

Example

  • Query authority rule configuration
SHOW AUTHORITY RULE;

mysql> SHOW AUTHORITY RULE;
+--------------------+---------------+-------+
| users              | provider      | props |
+--------------------+---------------+-------+
| root@%; sharding@% | ALL_PERMITTED |       |
+--------------------+---------------+-------+
1 row in set (0.07 sec)

Reserved word

SHOW, AUTHORITY, RULE