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 wwv_flow_security.g_flow_id, p_user_name in varchar2, p_role_static_ids in wwv_flow_t_varchar2 );
Parameters
Table 2-8 REPLACE_USER_ROLES Procedure Signature 2 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 case insensitive |
Example
The following example shows how to use REPLACE_USER_ROLES
procedure to replace existing roles to new role static IDs of 'ADMINISTRATOR'
and 'CONTRIBUTOR'
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_static_ids => wwv_flow_t_varchar2( 'ADMINISTRATOR', 'CONTRIBUTOR' ) ); end;
Parent topic: APEX_ACL