DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007


    Hi All,

    my senario is i have created a context from schema 'Schema1' using "accessed globally" option and created on package to set the values for conext. It is working fine.

    When i deploy the same package on schema2 (remember the context is on schema1) and try to execute it on schema2 then it is giving me the following error. any help will be much appreciated.

    attached the test package for reference.

    Connected to:
    Oracle Database 10g Release - Production

    SQL> exec krishna_pkg.MyProcedure
    BEGIN krishna_pkg.MyProcedure; END;

    ERROR at line 1:
    ORA-01031: insufficient privileges
    ORA-06512: at "SYS.DBMS_SESSION", line 90
    ORA-06512: at "LGE2008DEV.KRISHNA_PKG", line 6
    ORA-06512: at line 1
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2008
    Schema2 does not have all the necessary privileges in order to access the package you created in schema1. Does schema2 have execute privilege on the said package - and the necessary priviliege(s) to access all objects referenced within the package?
    You need to check that.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.