CREATE CONTEXT

Purpose

The CREATE CONTEXT statement can create a namespace for a context (a set of application-defined attributes used for authentication and securing applications). It can also associate the namespace with an externally created package used to set that context.

Users use the DBMS_SESSION.SET_CONTEXT procedure in the specified package to set or reset the attributes of the context.

Syntax

CREATE [ OR REPLACE ] CONTEXT namespace
USING [ schema. ] package_name
[ INITIALIZED { EXTERNALLY | GLOBALLY }
| ACCESSED GLOBALLY
]

Syntax description

Examples

• Create a context namespace named dev_context.

  obclient> CREATE OR REPLACE CONTEXT dev_context USING SYS.DBMS_SESSION ACCESSED GLOBALLY;
  

• Use the SYS_CONTEXT function to control data access based on this context. In the following example, the emp_mgmt package has defined the deptno attribute as the department identifier. You can create a view based on the deptno value to restrict access to employee data in the base table.

  -- First, create the emp table.
  obclient> CREATE TABLE emp (
       empno NUMBER(4) PRIMARY KEY,
       ename VARCHAR2(10),
       job VARCHAR2(9),
       mgr NUMBER(4),
       hiredate DATE,
       sal NUMBER(7,2),
       comm NUMBER(7,2),
       deptno NUMBER(2)
  );
  
  -- Create a view based on the context.
  obclient> CREATE VIEW dev_emp_view AS
       SELECT * FROM emp
       WHERE deptno = SYS_CONTEXT('dev_context', 'deptno');