SET_AUTHENTICATION_SCHEME Procedure

8.40 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

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

The following example activates authentication scheme "SSO-Production" and installs application f100.sql, then resets 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