|
[oracle-l]
||
[Date Prev]
[01-2007 Date Index]
[Date Next]
||
[Thread Prev]
[01-2007 Thread Index]
[Thread Next]
Re: Privilege - View (ORA-1031)
- From: "Shivaswamy Raghunath" <shivaswamykr@xxxxxxxxx>
- To: "Mladen Gogala" <mgogala@xxxxxxxxxxx>
- Date: Tue, 2 Jan 2007 15:10:04 -0500
Sorry, with GRANT OPTION.
On 1/2/07, Shivaswamy Raghunath <shivaswamykr@xxxxxxxxx> 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@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
>
>
|
|
