SET_DEEP_SEC Procedure

Use this procedure to override the Deep Data Security configuration for applications that are about to be installed.

Syntax

PROCEDURE apex_application_install.set_deep_sec (
    p_enabled            IN   BOOLEAN,
    p_db_resource_scope  IN   VARCHAR2     DEFAULT NULL,
    p_application_scope  IN   VARCHAR2     DEFAULT NULL );

Parameters

Parameter	Description
p_enabled	Override whether the application uses Deep Data Security or not.
p_db_resource_scope	OAuth scope of the Oracle AI Database registration within the identity provider.
p_application_scope	OAuth scope of the Application registration within the identity provider. When p_enabled is passed as TRUE, non-NULL values must be passed for both p_db_resource_scope and p_application_scope parameters. If p_enabled is false, both p_db_resource_scope and p_application_scope must be NULL. If p_enabled is passed as NULL, then the Deep Data Security configuration from the application export file is used.

Example

The following example enables Deep Data Security and sets Database Resource Scope as well as the Application Scope.

begin
    apex_application_install.clear_all;
    apex_application_install.set_workspace('TARGET_WORKSPACE');

    apex_application_install.set_deep_sec(
        p_enabled           => true,
        p_db_resource_scope => 'OracleDBAudience_DBScope',
        p_application_scope => 'APEXAppAudience_AppScope' );
end;