Re: O7_DICTIONARY_ACCESSIBILITY

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Mon, 27 Oct 2003 20:48:33 GMT
Message-ID: <Bwfnb.12527$4O1.685@nwrdny01.gnilink.net>

"zeb" <thierry.constant1.nospam_at_free.fr> wrote in message news:3f9d826f$0$27570$626a54ce_at_news.free.fr...
> Hi,
>
> I migrated a database from 7.3.4 to 8.1.7
> some users need acces to system views ( V$SESSION ...)
> so I put the parameter O7_DICTIONARY_ACCESSIBILITY = true
> but after that I can't access the system views ...
> Why ?
> I have to grant SELECT_CATALOG_ROLE to access system views.
> Any clue ?
>
> Thanks in advance
>
>

You will need to grant select_catalog_role to the users who want to query the data dictionary views.

07_dictionary_accessibility set to true will allow any user who has been granted "select any table" to select from tables owned by the sys user also.

Thats the way it is.

Also: Note that in 9i 07_dictionary_accessibility shoudl preferably be set to false and instead "select any dictionary" priv be granted to suers who need access to SYS tables.

Anurag Received on Mon Oct 27 2003 - 14:48:33 CST