Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Privilege - View (ORA-1031)

RE: Privilege - View (ORA-1031)

From: Pande, Rajendra <rajendra.pande_at_ubs.com>
Date: Tue, 2 Jan 2007 14:42:13 -0500
Message-ID: <125BE2CBD9387F458D424DCF96DEBEA802C1157F@psle19.xchg.pwj.com>


For you to select rows from the base tables of a view:

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/statemen ts_10002.htm#i2065646
<http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/stateme nts_10002.htm#i2065646>  


From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Shivaswamy Raghunath
Sent: Tuesday, January 02, 2007 2: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

Please do not transmit orders or instructions regarding a UBS account by e-mail. The information provided in this e-mail or any attachments is not an official transaction confirmation or account statement. For your protection, do not include account numbers, Social Security numbers, credit card numbers, passwords or other non-public information in your e-mail. Because the information contained in this message may be privileged, confidential, proprietary or otherwise protected from disclosure, please notify us immediately by replying to this message and deleting it from your computer if you have received this communication in error. Thank you.

UBS Financial Services Inc.
UBS International Inc.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 02 2007 - 13:42:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US