Re: Privilege - View (ORA-1031)

  • From: "Shivaswamy Raghunath" <shivaswamykr@xxxxxxxxx>
  • To: "Mladen Gogala" <mgogala@xxxxxxxxxxx>
  • Date: Tue, 2 Jan 2007 15:07:14 -0500

Hello.

Thanks everybody.

Grant on base table with ADMIN option will take care of this.  And I am
convinced, that is logical and sounds right.

Thanks,
Shiva

On 1/2/07, Mladen Gogala <mgogala@xxxxxxxxxxx> wrote:


 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

*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

GIF image

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2007