SELECT_CATALOG_ROLE or "SELECT ANY DICTIONARY", I believe it changed in 9i and it's documented in the Administrator's Guide, Managing User Privileges and Roles, Accessing Objects in the SYS Schema.


At 11:49 AM 3/5/2003 -0800, you wrote:


Previously, an account with the DBA role could
directly query oracle's internal tables
(user$, seg$, ts$, etc).  Now in 9.2.0.2,
it appears we can't.  Does anybody know
what version this changed in or where (or if)
it was documented.  A quick search on
MetaLink came up empty.

Matt

----
Matt Adams - GE Appliances - [EMAIL PROTECTED]
We have enough youth.
How about a fountain of intelligence?


Andy Rivenes
Email: [EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Andy Rivenes
 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).



Reply via email to