Boy do I feel stupid!
Thank you Mr. Khedr and Mr. Breitling. I know the views are there, but at first I
thought that maybe there were being created as part of the database creation process
in some cases. In the first database I looked at, the X_$ views had the same creation
date as the database
Yet another case of the right hand not knowing what the left hand is doing. Now I'm
curious to find out which team is creating those x_$ views.
> -Original Message-
> Mark Leith
>
> Check out Jacques e-mail address - he *works* for Quest ;)
--
Please see the official ORACLE-L FAQ: http:
Check out Jacques e-mail address - he *works* for Quest ;)
-Original Message-
Wolfgang Breitling
Sent: 15 November 2003 07:04
To: Multiple recipients of list ORACLE-L
Someone must have created sys.x_$ views on some of the sys.x$ tables.
Installing statspack does that for example for X$
Someone must have created sys.x_$ views on some of the sys.x$ tables.
Installing statspack does that for example for X$KCBFWAIT, X$KSPPSV,
X$KSPPI, and X$KSQST. Do you have quest? I believe it does it for some of
the x$ tables as well. I routinely do it for all x$ tables in my test
databases an
P.S. I forgot to mention that in all the databases (including the 8.1.7 databases) in
which I tried this, init parameter O7_DICTIONARY_ACCESSIBILITY was set to FALSE.
I always thought that one could not grant SELECT privilege on the SYS.X$ tables, and
to make them accessible to another user one
You need to check if the SYS.X_$ are views or tables.
I believe they are views for the X$
Waleed
-Original Message-
Sent: Friday, November 14, 2003 8:54 PM
To: Multiple recipients of list ORACLE-L
I always thought that one could not grant SELECT privilege on the SYS.X$
tables, and to m