SET_DEEP_SEC Procedure

Use this procedure to control whether the application uses Deep Data Security.

Syntax

PROCEDURE apex_application_admin.set_deep_sec (
    p_application_id     IN   NUMBER,
    p_enabled            IN   BOOLEAN,
    p_db_resource_scope  IN   VARCHAR2     DEFAULT NULL,
    p_application_scope  IN   VARCHAR2     DEFAULT NULL );

Parameters

Parameter	Description
p_application_id	The application ID.
p_enabled	Whether the app 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.

Example

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

begin
    apex_application_admin.set_deep_sec(
        p_application_id    => 100,
        p_enabled           => true,
        p_db_resource_scope => 'OracleDBAudience_DBScope',
        p_application_scope => 'APEXAppAudience_AppScope' );
end;