Add a role to a user.
Input
Parameter | Type | Description |
|---|---|---|
v_USERNAME | VARCHAR2 | Name of the user. |
v_ROLE_ID | NUMBER | ID of the role. |
Example
exec p_roleapi.ADDROLETOUSER(’USER1’, 8); |
Exceptions
• User 'USERNAME' must have the 'Administration' role.
• Username is NULL.
• User 'USERNAME' does not exist.
• ROLE_ID is NULL.
• Role ID value does not exist.
• User 'USERNAME' already has role 'role_id'