2.6 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 apex_application.g_flow_id,
p_user_name IN VARCHAR2,
p_role_id IN NUMBER );
Parameters
Table 2-6 REMOVE_USER_ROLE Procedure Signature 1 Parameters
Parameter | Description |
---|---|
|
The application ID from which you want to remove an assigned role from a user. Defaults to the current application. |
|
The case insensitive name of the application user to remove the role from. |
|
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;
Parent topic: APEX_ACL