SQL Guide : solidDB® 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 rolejname TO user_name
grant_privilege ::= DELETE | INSERT | SELECT |
      UPDATE [( column_identifier [, column_identijTier]... )] |
   REFERENCES [( column_identifier [, column_identifier]... )]
GRANT EXECUTE ON function_name
   TO {PUBLIC | user_name [, user_name]... |
      role_name [, role_name]... }
GRANT EXECUTE ON procedure_name
   TO {PUBLIC | userjname [, user_name]... |
      role_name [, role_name]... }
GRANT {SELECT | INSERT} ON event_name
   TO {PUBLIC | userjname [, user_name]... |
      role_name [, role_name]... }
GRANT {SELECT | UPDATE} ON sequence_name
   TO {PUBLIC | userjname [, user_name]... |
      role_name [, role_name]... }
Usage
The GRANT statement is used to:
grant privileges to the specified user or role
grant privileges to the specified user by giving the user the privileges of the specified role
When you grant a role to a user, the role may be one that you have created, or it may be a system-defined role, such as SYS_SYNC_ADMIN_ROLE or SYS_ADMIN_ROLE.
If you use the optional WITH GRANT OPTION, the user who receives the privilege can grant the privilege to other users.
Examples
GRANT GUEST_USERS TO CALVIN;
GRANT INSERT, DELETE ON TEST TO GUEST_USERS;
Related reference
REVOKE
Related information
See also
solidDB® SQL statements