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;

Related Topics
Advanced Queueing (DBMS_AQ)
Advanced Queueing (DBMS_AQADM)
DBMS_APPLICATION_INFO
DBMS_LOGSTDBY_CONTEXT
DBMS_RLS
DBMS_SESSION
DBMS_WM
Fine Grained Access Control
SYS_CONTEXT
System Privileges
Virtual Private Database
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx