6. Grant¶

6.1. Synopsis¶

GRANT <privileges>

  ON { <entries> | <find_expression> }

  TO <grantees>

find_expression ::=
  FIND ( { <type_expression> | <tag_expression> | NOT <tag_expression> } [ AND ... ] )

tag_expression ::=
  TAG = 'tag_name'

type_expression ::=
  TYPE = { BLOB | DEQUE | HSET | INT | INTEGER | STREAM | TAG | TS }

6.2. Description¶

GRANT will grant the specified privileges on the entries listed to the grantees listed.

6.3. Parameters¶

privileges: The name of the entries for which the privileges should be granted. The privileges will be merged with previously specified privileges for the entry. If no previous privileges are specified for that entry, then the default privileges of the user will be merged with the granted privileges.
entries: The name of the entries to modify privileges.
find_expression: When your tables are tagged, you can use inline key/value lookups to perform your query over multiple tables. To match all tables that have the tag “stocks”, you can use FIND(tag='stocks' AND type=ts).
grantees: The list of grantees to grant privileges to.

6.4. Examples¶

In the following examples, Alice and Bob have the SELECT default privileges.

Grant to the user Alice the SELECT privilege on a table:

GRANT SELECT ON table1 TO Alice

Since Alice had already the SELECT default privilege, Alice will not gain any additional privilege on table1.

Grant to the user Bob the INSERT privilege on two tables:

GRANT INSERT ON table1, table2 TO Bob

Since Bob had the SELECT default privilege, Bob can now SELECT and INSERT on table1 and table2.