REMOVE_USER_ROLE Procedure Signature 1

This procedure removes an assigned role from a user.

Syntax

APEX_ACL.REMOVE_USER_ROLE (
    p_application_id in number   default wwv_flow_security.g_flow_id,
    p_user_name      in varchar2,
    p_role_id        in number );

Parameters

Table 2-5 REMOVE_USER_ROLE Procedure Signature 1 Parameters

Parameter Description

p_application_id

The application ID from which you want to remove an assigned role from a user. Defaults to the current application.

p_user_name

The case insensitive name of the application user to remove the role from.

p_role_id

The ID of the role.

Example

The following example shows how to use REMOVE_USER_ROLE procedure to remove role ID of 2505704029884282 from the user name called 'SCOTT' in application 255.

begin
    APEX_ACL.REMOVE_USER_ROLE (
        p_application_id => 255,
        p_user_name      => 'SCOTT',
        p_role_id        => 2505704029884282 );
end;