Re: Privilege - View (ORA-1031)

Sorry, with GRANT OPTION.

On 1/2/07, Shivaswamy Raghunath <shivaswamykr_at_gmail.com> wrote:
>
> 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_at_vmsinfo.com> 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_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