GRANT ROLE statement
The GRANT ROLE statement assigns a role to a group or a user.
Granting roles to a group
Syntax:
GRANT ROLE role_name TO GROUP group_name;Granting roles to a user
Syntax:
GRANT ROLE <role_name> TO USER <user_name>;Example:
This example shows how to grant the grant_revoke_test_ALL_SERVER role to the getuser user.
GRANT ROLE grant_revoke_test_ALL_SERVER TO USER getuser;