RE: Privilege - View (ORA-1031)

  • From: "Kerber, Andrew" <Andrew.Kerber@xxxxxxx>
  • To: shivaswamykr@xxxxxxxxx, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 2 Jan 2007 13:04:15 -0600

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.

==============================================================================

Other related posts: