Q
Problem solve Get help with specific problems with your technologies, process and projects.

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 declared
From 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.
or
  • Have the user create a private synonym for sys.X$KGLOB after SYS granted select on X$KGLOB to the user.

For More Information


Dig Deeper on Oracle and SQL

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close