Oracle | Contexts

Oracle Contexts Version 19c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Be sure to view the full listing of monographs in Morgan's Library

Dependencies

ALL_CONTEXT	DBA_CONTEXT	SESSION_CONTEXT
CDB_CONTEXT	GLOBAL_CONTEXT	V$CONTEXT
CONTEXT$		CDB_GLOBAL_CONTEXT CONTEXT CONTEXT_V2 GV$GLOBALCONTEXT INT$DBA_CONTEXT I_CONTEXT KU$_CONTEXT_T KU$_CONTEXT_VIEW SEMCONTEXT USER_POLICY_CONTEXTS V$GLOBALCONTEXT VALIDATE_CONTEXT

Create Context

Create local context CREATE OR REPLACE CONTEXT <context_name> USING <plsql_package_name>;

CREATE OR REPLACE CONTEXT otp USING dbms_otp;

      

      col schema format a30

      col package format a30

      

      SELECT *

      FROM context$

      WHERE package = 'DBMS_OTP';

      

         OBJ# SCHEMA                         PACKAGE        FLAGS

      ------- ------------------------------ ------------- ------

        76296 SYS                            DBMS_OTP           0

Create global context CREATE OR REPLACE CONTEXT <context_name> USING <plsql_package_name> ACCESSED GLOBALLY;

CREATE OR REPLACE CONTEXT otp USING dbms_otp ACCESSED GLOBALLY;

      

      col schema format a30

      col package format a30

      

      SELECT *

      FROM context$

      WHERE package = 'DBMS_OTP';

      

         OBJ# SCHEMA                         PACKAGE        FLAGS

      ------- ------------------------------ ------------- ------

        76297 SYS                            DBMS_OTP           2

Drop Context

Drop Context drop context <context_name>;

drop context otp;