2 APEX_ACL
The APEX_ACL
package provides utilities that you can use when programming in the Oracle APEX environment related to the Shared Components for application access control. You can use the APEX_ACL
package to add, remove, or replace user roles. You can also use the INSTEAD OF
trigger on the APEX_APPL_ACL_USERS
view to edit user roles with DML statements (INSERT, UPDATE, and DELETE).
If the package is used outside of an APEX 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 APEX_APPL_ACL_ROLES
, APEX_APPL_ACL_USERS
, and APEX_APPL_ACL_USER_ROLES
to get more information on application users and roles.
- ADD_USER_ROLE Procedure Signature 1
- ADD_USER_ROLE Procedure Signature 2
- HAS_USER_ANY_ROLES Function
- HAS_USER_ROLE Function
- IS_ROLE_REMOVED_FROM_USER Function
- REMOVE_USER_ROLE Procedure Signature 1
- REMOVE_USER_ROLE Procedure Signature 2
- REPLACE_USER_ROLES Procedure Signature 1
- REPLACE_USER_ROLES Procedure Signature 2
- REMOVE_ALL_USER_ROLES Procedure