This procedure enables groups in the current session. These groups do not have to be created in the Application Express workspace repository, but can, for example, be loaded from a LDAP repository. Enabling a group that exists in the workspace repository and has other groups granted to it, also enables the granted groups.
If Real Application Security, available with Oracle Database Release 12g, is enabled for the authentication scheme, all dynamic groups are enabled as RAS dynamic or external groups (depending whether the group exists in
This procedure must be called during or right after authentication, for example, in a post-authentication procedure.
APEX_AUTHORIZATION.ENABLE_DYNAMIC_GROUPS ( p_group_names IN apex_t_varchar2 );
Table 4-1 ENABLE_DYNAMIC_GROUPS Procedure Parameter
Table of group names.
This example enables the dynamic groups
HR, for example, from within a post authentication procedure.
begin apex_authorization.enable_dynamic_groups ( p_group_names => apex_t_varchar2('SALES', 'HR') ); end;
APEX_WORKSPACE_SESSION_GROUPS and View