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

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

Privilege - View (ORA-1031)

From: Shivaswamy Raghunath <shivaswamykr_at_gmail.com>
Date: Tue, 2 Jan 2007 14:00:02 -0500
Message-ID: <1e52ad820701021100q2923db41k80d08df6a6766af5@mail.gmail.com> 





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


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


Received on Tue Jan 02 2007 - 13:00:02 CST












Original text of this message













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