2.2 ADD_USER_ROLE Procedure Signature 2
This procedure assigns a role to a user.
Syntax
APEX_ACL.ADD_USER_ROLE (
p_application_id IN NUMBER DEFAULT apex_application.g_flow_id,
p_user_name IN VARCHAR2,
p_role_static_id IN VARCHAR2 )
Parameters
Parameter | Description |
---|---|
p_application_id |
The application ID for which you want to assign a role to a user. Defaults to the current application. |
p_user_name |
The case-insensitive name of the application user to assign the role to. |
p_role_static_id |
The case-insensitive name of the role static ID. |
Example
The following example uses the ADD_USER_ROLE
procedure to assign the role static ID 'ADMINISTRATOR'
to the user name called 'SCOTT'
in application 255
.
BEGIN
APEX_ACL.ADD_USER_ROLE (
p_application_id => 255,
p_user_name => 'SCOTT',
p_role_static_id => 'ADMINISTRATOR' );
END;
Parent topic: APEX_ACL