Oracle Contexts
Version 12.1.0.2

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.
Dependencies
ALL_CONTEXT DBA_CONTEXT SESSION_CONTEXT
CDB_CONTEXT GLOBAL_CONTEXT V$CONTEXT
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';
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';
 
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 12cR1
What's New In 12cR2

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