solidDB Help : solidDB reference : SQL: Statements : GRANT
  
GRANT
GRANT {ALL | grant‑privilege [, grant‑privilege …]}
   ON table‑name TO {PUBLIC | user‑name [, user‑name …] |
   role‑name [, role‑name …]} [WITH GRANT OPTION]
GRANT role‑name TO user‑name
GRANT EXECUTE ON {function‑name | procedure‑name}
   TO {PUBLIC | user‑name [, user‑name …] | role‑name [, role‑name …]}
GRANT {SELECT | INSERT} ON {event‑name | sequence‑name}
   TO {PUBLIC | user‑name [, user‑name …] | role‑name [, role‑name …]}
where:
grant‑privilege::= DELETE | INSERT | SELECT |
   UPDATE [( column‑identifier [, column‑identifier …])] |
   REFERENCES [( column‑identifier [, column‑identifier …])]
Access requirements
SYS_ADMIN_ROLE role (or a user who was granted the privilege with the WITH GRANT OPTION).
Usage
Use the GRANT statement to perform the following tasks:
▪ grant individual privileges to a specified user or role,
▪ grant a role to a specified user, which gives the user all the privileges of the specified role.
When you grant a role to a user, the role can be a user-defined role or a system-defined role, such as SYS_SYNC_ADMIN_ROLE or SYS_ADMIN_ROLE.
Parameters, clauses, keywords, and variables
▪ WITH GRANT OPTION: The user who receives the privilege can grant the privilege to other users.
▪ Privileges:
– DELETE: User can delete rows from the specified table.
– INSERT: User can add rows to the specified table.
– SELECT: User can query the specified table.
– UPDATE: User can update all or specified columns in a row of the specified table.
– REFERENCES: User can create a table that has a foreign key reference to the specified table. If columns are specified, the user can only use the foreign key reference with the specified columns.
– EXECUTE ON: User can execute the specified procedure or function.
– ALL: User has all privileges.
Examples
GRANT GUEST_USERS TO CALVIN;
GRANT INSERT, DELETE ON TEST TO GUEST_USERS;
Go up to
SQL: Statements