2.6 REMOVE_USER_ROLE Procedure Signature 2

This procedure removes an assigned role from a user.

Syntax

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

Parameters

Table 2-6 REMOVE_USER_ROLE Procedure Signature 2 Parameters

Parameter	Description
`p_application_id`	The application ID from which you want to remove an assigned role from a user. It defaults to the current application.
`p_user_name`	The case insensitive name of the application user to remove the role from.
`p_role_static_id`	The case insensitive name of the role static ID.

Example

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

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

Parent topic: APEX_ACL