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$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 and grant select to the select_catalog_role. Then I can access the x$tables without having to log on as sys. In my test databases I always At 07:14 PM 11/14/2003, you wrote: >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 would have to >create a view on the table (as mentioned on Steve Adams' ixora website: >http://www.ixora.com.au/scripts/prereq.htm >create_xviews.sql) > >However someone told me recently that you could grant SELECT on sys.X_$... > >When I tried this, I saw results that confused me. >In Database A, Oracle 8.1.7.4.1, Windows 2000 server, I was able to >1- grant select on SYS.X_$KTFBFE to another_user ; >2- grant select on SYS.X_$KTFBHC to another_user ; >3- grant select on SYS.X_$KTFBUE to another_user ; > >BUT > >4- grant select on SYS.X_$KDXST to another_user ; >returns ORA-00942 table or view does not exist. > >In database B, using the same ORACLE_HOME as database A (i.e. identical >Oracle version and OS) >even the first three grant statements returned ORA-00942 > >When I tried it on more recent Oracle databases on Windows / SunOS >servers, it worked intermittently: >Oracle 9.0 (SunOS): all GRANTS failed >Oracle 9.2 (SunOS): GRANTS 1-3 were successful, GRANT 4 failed >Oracle 10.1 beta (Windows 2000): all GRANTS failed > >Does anyone know the reason for this strange behaviour? >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Jacques Kilchoer > INET: [EMAIL PROTECTED] > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com >San Diego, California -- Mailing list and web hosting services >--------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
