Skip to Main Content

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!

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

1061941Jan 25 2014 — edited Feb 12 2014

I have created one context using "create or replace context LHS_VAR Using package_name"  command and first time i grant them

SYS-LOGIN

Grant Create ANY CONTEXT TO ADAMTEST;
GRANT Execute On DBMS_SESSION To ADAMTEST;
GRANT CREATE TRIGGER TO ADAMTEST;

USER-LOGIN

create or replace context LHS_VAR Using lhs_utility

after granting i can succefully set the context with lhs_utility.set_var_data('entity_code', 'AD'); command and its working fine but when i am login next day then i am getting error like

ORA-01031: insufficient previleges

ORA-06512: at "user.package" like 5059



Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2014
Added on Jan 25 2014
3 comments
2,667 views