Home » RDBMS Server » Server Administration » SELECT_CATALOG_ROLE Vs SELECT ANY DICTIONARY in Oracle9i
SELECT_CATALOG_ROLE Vs SELECT ANY DICTIONARY in Oracle9i [message #56850] Wed, 30 April 2003 09:42 Go to next message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
I am working on the conversion of our databases from 8.1.7 to 9.2.0.

I want to know the difference in the use of SELECT_CATALOG_ROLE and SELECT ANY DICTIONARY. With Oracle8i, the SELECT_CATALOG_ROLE worked fine, specially when certain users needed to use the OEM.

Now with 9i, SELECT ANY DICTIONARY is recommended (as per the upgrade Doc).

I did some small testing and with either one of the priviledges, I could navigate the Dictionary tables and OEM.

Any suggestions ?? Which is a better practice to do ?

Thanx.

Report message to a moderator

Re: SELECT_CATALOG_ROLE Vs SELECT ANY DICTIONARY in Oracle9i [message #56852 is a reply to message #56850] Wed, 30 April 2003 10:29 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
i beleive
SELECT_CATALOG_ROLE provides access to all SYS views only. 
SELECT ANY DICTIONARY system privilege provides access to SYS schema objects only.

Report message to a moderator

Previous Topic: Oracle 8i EE
Next Topic: using clob
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:52:19 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.