The functions/procedures in the P_ROLEAPI package are used to change roles assigned to users.
Name
Type
Description
ADDROLETOUSER
Procedure
Add a role to a user.
REMOVEROLEFROMUSER
Remove a role from a user.