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