Examples Of Role Assignment

Assigning the DIRECTOR and MANAGER roles to the user IVAN:

GRANT DIRECTOR, MANAGER
  TO USER IVAN;

Assigning the MANAGER role to the user ALEX with the authority to assign this role to other users:

GRANT MANAGER
  TO USER ALEX WITH ADMIN OPTION;

Assigning the DIRECTOR role to user ALEX as a default role:

GRANT DEFAULT DIRECTOR
  TO USER ALEX;

Assigning the MANAGER role to role DIRECTOR:

GRANT MANAGER
  TO ROLE DIRECTOR;