| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/prvtctx.plb |
| First Available |
9.0.1 |
| Dependencies |
|
| Security Model |
Owned by SYS with no privileges granted |
| |
| CLEAR_CONTEXT |
| Checks the AppCtxPermit Object and performs a clear Context |
dbms_appctx.clear_context(
schema IN VARCHAR2,
class IN VARCHAR2,
namespace IN VARCHAR2,
client_id IN VARCHAR2,
attribute IN VARCHAR2); |
| TBD |
| |
| SET_CONTEXT |
| Checks the AppCtxPermit Object and performs a set Contex |
dbms_appctx.set_context(
schema IN VARCHAR2,
class IN VARCHAR2,
namespace IN VARCHAR2,
attribute IN VARCHAR2,
value IN VARCHAR2,
username IN VARCHAR2,
client_id IN VARCHAR2); |
conn / as sysdba
GRANT create context TO uwclass;
conn uwclass/uwclass
desc dba_contexts
SELECT *
FROM dba_context;
CREATE OR REPLACE
CONTEXT uwctx USING set_contxt;
SELECT * FROM dba_context;
SQL> exec sys.dbms_appctx.set_context('UWCLASS', 'UWCTX', 'UWCONTEXT', 'MyAttr', '1', user, NULL);
BEGIN dbms_appctx.set_context('UWCLASS', 'UWCTX', 'UWCONTEXT', 'MyAttr', '1', user, NULL); END;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_APPCTX", line 14
ORA-06512: at line 1 |
|
