Re: Privilege - View (ORA-1031)

Andrew,

May be I was not clear.?

I understand with Select any table, User C is able to select from view V. But my question is why Select any table is required, when privlege to select on the view is already there.?

Shiva

On 1/2/07, Kerber, Andrew <Andrew.Kerber_at_umb.com> wrote:
>
> 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
>
>
>
>
> "If at first you dont succeed, dont take up skydiving"
>
> -----Original Message-----
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Shivaswamy Raghunath
> *Sent:* Tuesday, January 02, 2007 1:00 PM
> *To:* ORACLE-L
> *Subject:* Privilege - View (ORA-1031)
>
>
>
> Hello.
>
> Version - 10.1.0.5.0.
>
> User C is NOT able to select (ORA-1031) from a View V in Schema A (On
> which C has select privilege), which is based on a table in Schema B.
>
> If user C is granted Select any Table, he is able to select from the view
> V.
>
> This does not loook logical to me. Have you come across this?
>
> Thanks,
> Shiva
>
>
> ------------------------------------------------------------------------------
> NOTICE: This electronic mail message and any attached files are
> confidential. The information is exclusively for the use of the individual
> or entity intended as the recipient. If you are not the intended recipient,
> any use, copying, printing, reviewing, retention, disclosure, distribution
> or forwarding of the message or any attached file is not authorized and is
> strictly prohibited. If you have received this electronic mail message in
> error, please advise the sender by reply electronic mail immediately and
> permanently delete the original transmission, any attachments and any copies
> of this message from your computer system. Thank you.
>
>
> ==============================================================================
>

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