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;
Parent topic: APEX_ACL