4.29 SET_AUTHENTICATION_SCHEME Procedure

Use this procedure to override the active authentication scheme for the applications that are about to be installed.

Syntax

APEX_APPLICATION_INSTALL.SET_AUTHENTICATION_SCHEME(
      p_name IN VARCHAR2 );

Parameters

Table 4-10 SET_AUTHENTICATION_SCHEME Parameters

Parameter Description

p_name

The name of the authentication scheme to be activated. This new authentication scheme must exist in the application. If null, the active authentication scheme will remain unchanged.

Example

Activate authentication scheme "SSO-Production" and install application f100.sql, then reset the override for f101.sql to keep its active scheme.

begin
  apex_application_install.set_authentication_scheme (
      p_name => 'SSO-Production' );
end;
/
@f100.sql
begin
  apex_application_install.set_authentication_scheme (
      p_name => null );
end;
/
@f101.sql