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@xxxxxxxxxxx x72546 904 727-2546 ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mladen Gogala Sent: Tuesday, January 02, 2007 2:54 PM To: Andrew.Kerber@xxxxxxx; shivaswamykr@xxxxxxxxx; '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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kerber, Andrew Sent: Tuesday, January 02, 2007 2:04 PM To: shivaswamykr@xxxxxxxxx; 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