2.9 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-9 REMOVE_ALL_USER_ROLES Procedure Parameters

Parameter	Description
p_application_id	The application ID for which you want to remove all assigned roles from a user. Defaults to the current application.
p_user_name	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;