2.10 REMOVE_ALL_USER_ROLES Procedure
This procedure removes all assigned roles from a user.
Syntax
APEX_ACL.REMOVE_ALL_USER_ROLES (
p_application_id IN NUMBER default apex_application.g_flow_id,
p_user_name IN VARCHAR2 );
Parameters
Table 2-10 REMOVE_ALL_USER_ROLES Procedure Parameters
Parameter | Description |
---|---|
|
The application ID for which you want to remove all assigned roles from a user. Defaults to the current application. |
|
The case insensitive name of the application user to remove all assigned roles. |
Example
The following example shows how to use REMOVE_ALL_USER_ROLES
procedure to removes all assigned roles from the user name called 'SCOTT'
in application 255
.
begin
APEX_ACL.REMOVE_ALL_USER_ROLES (
p_application_id => 255,
p_user_name => 'SCOTT' );
end;
Parent topic: APEX_ACL