GRANTEXECUTEONfunction_name TO {PUBLIC | user_name [,user_name]... | role_name [,role_name]... }
GRANTEXECUTEONprocedure_name TO {PUBLIC | userjname [,user_name]... | role_name [,role_name]... }
GRANT {SELECT | INSERT} ONevent_name TO {PUBLIC | userjname [,user_name]... | role_name [,role_name]... }
GRANT {SELECT | UPDATE} ONsequence_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;