ENABLE_DYNAMIC_GROUPS Procedure

7.1 ENABLE_DYNAMIC_GROUPS Procedure

This procedure enables groups in the current session. These groups do not have to be created in the Application Express workspace repository, but can be loaded from an LDAP repository or retrieved from a trusted HTTP header. 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 dba_xs_dynamic_roles).

This procedure must be called during or right after authentication, for example, in a post-authentication procedure.

Syntax

APEX_AUTHORIZATION.ENABLE_DYNAMIC_GROUPS (
    p_group_names IN apex_t_varchar2 );

Parameters

Table 7-1 ENABLE_DYNAMIC_GROUPS Procedure Parameter

Parameter	Description
`p_group_names`	Table of group names.

Example

This example enables the dynamic groups SALES and HR from within a post authentication procedure.

begin
   apex_authorization.enable_dynamic_groups (
       p_group_names => apex_t_varchar2('SALES', 'HR') );
end;