CARIS HPD : HPD® Server API : User Setup : P_ROLEAPI : ADDROLETOUSER
 

ADDROLETOUSER

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'