18. SHOW GRANTS#

18.1. Synopsis#

SHOW GRANTS

  ON { <entries> | <find_expression> }

find_expression ::=
  FIND (
    { TAG = <tag_value> | NOT TAG = <tag_value>
      | PREFIX = 'prefix' | SUFFIX = 'suffix' | TYPE = TS }
    [ AND ... ] [ , RECURSIVE = { TRUE | FALSE } ]
  )

tag_value ::= { 'text' | $table } [ || ... ]

18.2. Description#

SHOW GRANTS lists the explicit access control for a database entry. This command requires the GET_ACL privilege.

..note ::: If the entry does not exist, SHOW GRANTS returns an empty list. This behavior prevents a user with the GET_ACL privilege from finding entry names.

18.3. Parameters#

entries: The names of the entries whose access control lists QuasarDB returns.

18.4. Examples#

List the privileges on one table:

SHOW GRANTS ON table1

List the privileges for entries that have the nyse tag:

SHOW GRANTS ON FIND(tag='nyse')