GRANT

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

Managing user privileges and roles