SHOW AUTHORITY RULE

Description

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

Syntax

Grammar Railroad diagram

  1. ShowAuthorityRule ::=
  2.   'SHOW' 'AUTHORITY' 'RULE'

Return Value Description

ColumnDescription
usersusers
providerprivilege provider type
propsprivilege properties

Example

  • Query authority rule configuration
  1. SHOW AUTHORITY RULE;
  1. mysql> SHOW AUTHORITY RULE;
  2. +--------------------+---------------+-------+
  3. | users              | provider      | props |
  4. +--------------------+---------------+-------+
  5. | root@%; sharding@% | ALL_PERMITTED |       |
  6. +--------------------+---------------+-------+
  7. 1 row in set (0.07 sec)

Reserved word

SHOW, AUTHORITY, RULE