Page 1 of 1

Add or Remove Roles

Posted: Thu Nov 18, 2021 2:19 am
by admin
apex_acl.add_user_role
( p_application_id => wwv_flow_security.g_flow_id,
, p_user_name => p_app_user
, p_role_static_id => 'ACCOUNTANT'
);

apex_acl.remove_user_role
( p_application_id => default wwv_flow_security.g_flow_id,
, p_user_name => p_app_user
, p_role_static_id => 'ACCOUNTANT'
);

APEX_ACL.REMOVE_ALL_USER_ROLES (
p_application_id in number wwv_flow_security.g_flow_id,
p_user_name in varchar2 );

APEX_ACL.REPLACE_USER_ROLES (
p_application_id IN NUMBER DEFAULT apex_application.g_flow_id,
p_user_name IN VARCHAR2,
p_role_ids IN apex_t_number );