Granting privileges to a user by giving the user a role

SQL Guide : Using SQL for database administration : Managing user privileges and roles : Granting privileges to a user by giving the user a role

Granting privileges to a user by giving the user a role

GRANT role_name TO username ;

The following example gives the user CALVIN the privileges that are defined for the GUEST_USERS role.

GRANT GUEST_USERS TO CALVIN;

See also

Managing user privileges and roles