RE: Privilege - View (ORA-1031)

From: Kerber, Andrew <Andrew.Kerber_at_umb.com>
Date: Tue, 2 Jan 2007 13:04:15 -0600
Message-ID: <D40740337A3B524FA81DB598D2D7EBB305776FD3@x6009a.umb.corp.umb.com>

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

Received on Tue Jan 02 2007 - 13:04:15 CST