This procedure removes all assigned roles from a user.
APEX_ACL.REMOVE_ALL_USER_ROLES ( p_application_id in number default wwv_flow_security.g_flow_id, p_user_name in varchar2 );
Table 2-9 REMOVE_ALL_USER_ROLES Procedure Parameters
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.
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
begin APEX_ACL.REMOVE_ALL_USER_ROLES ( p_application_id => 255, p_user_name => 'SCOTT' ); end;