2 APEX_ACL

The APEX_ACL package provides utilities that you can use when programming in the Oracle Application Express environment related to application access control shared components. You can use APEX_ACL package to add, remove, or replace user roles. You can also take advantage of INSTEAD OF trigger on APEX_APPL_ACL_USERS view to edit user roles with DML statements (INSERT, UPDATE, and DELETE). If the package is used outside of an Oracle Application Express environment, the security_group_id must be set using either APEX_UTIL.SET_WORKSPACE or APEX_UTIL.SET_SECURITY_GROUP_ID before the call. Use the related APEX views to get more information on application users and roles are APEX_APPL_ACL_ROLES, APEX_APPL_ACL_USER_ROLES, and APEX_APPL_ACL_USERS.