Oracle 12c OWA_CUSTOM Demos

Oracle OWA_CUSTOM Version 12.1.0.2

General Information

Library Note

Morgan's Library Page Footer

The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,

Purpose

Sets up values to be used by other Web Agent packages.

AUTHID

DEFINER

Dependencies

OWA	OWA_GLOBAL	OWA_SEC
OWA_COOKIE	OWA_INIT	WWV_OWA_COOKIE

Documented

First Available

8.1.7

Security Model

Owned by SYS with EXECUTE granted to PUBLIC and APEX_040200

Source

{ORACLE_HOME}/rdbms/admin/privcust.sql

AUTHORIZE

Global PLSQL Agent Authorization callback function. It is used when PLSQL Agent's authorization scheme is set to GLOBAL or CUSTOM when there is overriding OWA_CUSTOM package. This is a default implementation that the developer should modify.

owa_custom.authorize RETURN BOOLEAN;

-- source code
FUNCTION authorize RETURN BOOLEAN IS
BEGIN
owa_sec.set_protection_realm('To-be-defined realm');
RETURN FALSE;
END;

INITIALIZATION SECTION

Package initialization section

-- source code
BEGIN /* OWA_CUSTOM package customization */

/*******************************************************************/
/* Set the PL/SQL Agent's authorization scheme                     */
/* This should be modified to reflect the authorization need of    */
/* your PLSQL Agent                                                */
/*******************************************************************/
owa_sec.set_authorization(OWA_SEC.NO_CHECK);
END;
/