1.7 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 1-7 REPLACE_USER_ROLES Procedure Signature 1 Parameters
Parameter | Description |
---|---|
|
The application ID for which you want to replace user role. Defaults to the current application. |
|
The case insensitive name of the application user to replace the role. |
|
The array of |
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;
Parent topic: APEX_ACL