Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: V$

Re: V$

From: Don Granaman <granaman_at_cox.net>
Date: Thu, 08 May 2003 19:31:56 -0800
Message-ID: <F001.00594CA4.20030508193156@fatcity.com>


I'll add one more option...
e) grant select any dictionary to <whomever>;

The change between 8i and 9i that causes this common consternation is that, as Kirti mentioned, the default for the initialization parameter o7_dictionary_accessibility changed from TRUE (8i) to FALSE (9i).

Don Granaman
OraSaurus

  It is likely that the user id had (or has) 'select any table' privilege.

  In Oracle9i, this privilege will not work when accessing any 'SYS' owned objects, because the initialization parameter   O7_DICTIONARY_ACCESSIBILITY defaults to FALSE.

  To solve this problem you may follow one of these:

  1. Set O7_DICTIONARY_ACCESSIBILITY to TRUE
  2. As Raj mentioned, log in 'as sysdba'
  3. Grant 'SELECT_CATALOG_ROLE' to the user
  4. Explicitly grant select privilege on the SYS owned objects to the user.
    • Kirti -----Original Message----- From: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni_at_espn.com] Sent: Tuesday, May 06, 2003 9:17 AM To: Multiple recipients of list ORACLE-L Subject: RE: V$

    Amit,
    You must have dropped them over the desk, look under the chair ... or Send USD4000 and SASE to following address ... and we will send you a fresh copy.

    Seriously, you need to log in "as sysdba" to see them.

    ps: if you are wondering about the 4K figure, it goes to my Plasma TV fund, I believe it will be good for my eye-sight.

    Raj



    Rajendra dot Jamadagni at nospamespn dot com     All Views expressed in this email are strictly personal.     QOTD: Any clod can have facts, having an opinion is an art !
      -----Original Message-----
      From: Amit Valia [mailto:forml2003_at_yahoo.com]
      Sent: Tuesday, May 06, 2003 3:07 AM
      To: Multiple recipients of list ORACLE-L
      Subject: V$


        I've just installed Oracle 91 on my machine. Earlier I used to see the V$ views but am no longer able to see them. Is there a way I can find out if any objects have been deleted or not and such details ?

        Thank you.

        Amit Valia



--------------------------------------------------------------------------
      Do you Yahoo!?
      The New Yahoo! Search - Faster. Easier. Bingo.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Don Granaman
  INET: granaman_at_cox.net

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: ListGuru_at_fatcity.com (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). Received on Thu May 08 2003 - 22:31:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US