SQL & PL/SQL

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!

Insuficient Privileges for SYS.DBMS_SESSION.SET_CONTEXT

386321Aug 25 2005 — edited Aug 25 2005

Hi,

I am not able to use sys.dbms_session.set_context(...).

Always get this error:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SESSION", line 82

I granted the privileges "Execute any procedure and even sysoper and sysdba privileges" to the user I want to be able to set_context.

Does it require any other privilege?

Thanks,
Nuno Vidal

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 22 2005

Added on Aug 25 2005

2 comments

2,107 views