X$KGLOB not visible
On trying to compile a package body, I am getting the following error:
LINE/COL ERROR -------- ----------------------------------------- 23/7 PL/SQL: SQL Statement ignored 23/48 PLS-00201: identifier 'X$KGLOB' must be declaredFrom this user, DESC X$KGLOB gives an 'object does not exist' error, but from SYS it is fine. What haven't I done to make X$KGLOB 'visible' to the other user?
In order to have a user "recognize" X$KGLOB, you have to either:
- Create a public synonym for the X$KGLOB in SYS and grant select on X$KGLOB to PUBLIC.
- Have the user create a private synonym for sys.X$KGLOB after SYS granted select on X$KGLOB to the user.
For More Information
- Dozens more answers to tough Oracle questions from Eli Leiba are available here.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.