To grant roles to users or other roles, use:
grant role role_granted [{, role_granted}...]
to grantee [{, grantee}...]
where:
role_granted – is the role being granted. You can specify any number of roles to be granted.
grantee – is the name of the user or role. You can specify any number of grantees.
All roles listed in the grant statement are granted to all grantees. If you grant one role to another, it creates a role hierarchy.
For example, to grant Susan, Mary, and John the “financial_analyst” and the “payroll_specialist” roles, enter:
grant role financial_analyst, payroll_specialist to susan, mary, john
