2.9 REPLACE_USER_ROLES Procedure Signature 2

This procedure replaces any existing assigned user roles to a 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_static_ids IN apex_t_varchar2 );

Parameters

Parameter	Description
p_application_id	The application ID for which you want to replace the user roles. Defaults to the current application.
p_user_name	The case insensitive name of the application user to replace the role.
p_role_static_ids	The array of case-insensitive VARCHAR2-type role static IDs.

Example

The following example uses the REPLACE_USER_ROLES procedure to replace existing roles with new role static IDs of 'ADMINISTRATOR' and 'CONTRIBUTOR' for the user name 'SCOTT' in application 255.

BEGIN
    APEX_ACL.REPLACE_USER_ROLES (
        p_application_id  => 255,
        p_user_name       => 'SCOTT',
        p_role_static_ids => apex_t_varchar2( 'ADMINISTRATOR', 'CONTRIBUTOR' ) );
END;