Privilege - View (ORA-1031)
Privilege - View (ORA-1031) -- Shivaswamy Raghunath 2007-01-02
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?