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: Privilege - View (ORA-1031)

RE: Privilege - View (ORA-1031)

From: <Joel.Patterson_at_crowley.com>
Date: Tue, 2 Jan 2007 16:05:18 -0500
Message-ID: <02C2FA1C9961934BB6D16DE35707B27B026E8816@jax-mbh-01.jax.crowley.com>


Use SELECT ANY DICTIONARY or SELECT_CATALOG_ROLE or O7_DICTIONARY_ACCESSIBILITY? Note: 153510.1 explains the combinations fairly well.    

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala
Sent: Tuesday, January 02, 2007 2:54 PM
To: Andrew.Kerber_at_umb.com; shivaswamykr_at_gmail.com; 'ORACLE-L' Subject: RE: Privilege - View (ORA-1031)  

Actually, in version 10, you can not select from the dictionary tables with "SELECT ANY TABLE". You also need "SELECT ANY DICTIONARY".

In version 10, the phrase "any table" doesn't include the dictionary tables.    

Mladen Gogala
Sr. Oracle DBA
1500 Broadway, 6th floor
New York, NY 10036
(212) 329-5201
www.vmsinfo.com <http://www.vmsinfo.com/>

The Leader in Integrated Media Intelligence Solutions  


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kerber, Andrew
Sent: Tuesday, January 02, 2007 2:04 PM
To: shivaswamykr_at_gmail.com; ORACLE-L
Subject: RE: Privilege - View (ORA-1031)  

Yes, I think that is the definition of select any table. You can select on any table or view in the database.  

Andrew W. Kerber
Oracle DBA
UMB  


--
http://www.freelists.org/webpage/oracle-l


image001.gif
Received on Tue Jan 02 2007 - 15:05:18 CST

Original text of this message

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