Insufficient privileges in DBMS_SESSION.SET_CONTEXT [message #610713] |
Sun, 23 March 2014 08:40 |
Andrey_R
Messages: 441 Registered: January 2012 Location: Israel
|
Senior Member |
|
|
Hi all,
I have a code that is using DBMS_SESSION.SET_CONTEXT,
But as I am digging it to try to realize what is wrong,
I am finding out that even SYS gets an error in trying to set the context:
SQL> show user
USER is "SYS"
SQL>
SQL> begin
2 DBMS_SESSION.SET_CONTEXT('bla',
3 'blabla',
4 '1');
5 end;
6 /
begin
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SESSION", line 101
ORA-06512: at line 2
SQL>
This object is documented to be owned by SYS, so I don't understand how can this be and how to overcome it?
Thanks in advance,
Andrey R.
|
|
|
|
|
|
|