General Information
Library Note
Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com . Request a Workshop for
your organization today.
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;