2.8 REPLACE_USER_ROLES Procedure Signature 1

This procedure replaces any existing assigned user roles to new array of roles.

Syntax

APEX_ACL.REPLACE_USER_ROLES (
    p_application_id IN NUMBER   DEFAULT apex_application.g_flow_id,
    p_user_name      IN VARCHAR2,
    p_role_ids       IN apex_t_number );

Parameters

Table 2-8 REPLACE_USER_ROLES Procedure Signature 1 Parameters

Parameter	Description
p_application_id	The application ID for which you want to replace user role. Defaults to the current application.
p_user_name	The case insensitive name of the application user to replace the role.
p_role_ids	The array of NUMBER type role IDs.

Example

The following example shows how to use REPLACE_USER_ROLES procedure to replace existing roles to new role IDs of 2505704029884282, 345029884282 for the user name called 'SCOTT' in application 255.

begin
    APEX_ACL.REPLACE_USER_ROLES (
        p_application_id => 255,
        p_user_name      => 'SCOTT',
        p_role_ids       => apex_t_number( 2505704029884282, 345029884282 ) );
end;