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@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *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.
==============================================================================
