Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[Solved] Problem with DBMS_SESSION.SET_CONTEXT

392825Oct 15 2007 — edited Jan 22 2013
Hi all,

I've created an application context and want to set it in a user other than sys, but I get the following error:

ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SESSION", line 90

I've granted 'execute on DBMS_SESSION' privilege to my user, even I've granted sysdba role to it but still I get the above error. How can I solve this?


Thanks in advance,
S/\EE|)

Message was edited by:
Saeed Shafieian
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2013
Added on Oct 15 2007
16 comments
45,709 views