Unable to select from View. Select granted to Role
Hello
I am trying to grant select rights on a view to a role but I'm unable to get this working correctly.
I have a user FRED which has role READ_ONLY.
The role READ_ONLY has been granted select rights to a view JOE.JOES_VIEW. This view selects from table MARY.BASE_TABLE.
The role READ_ONLY has select rights on table MARY.BASE_TABLE. User FRED can select from MARY.BASE_TABLE (by virtue of the role).
But when FRED tries to select from JOE.JOES_VIEW he gets "ORA-01031: insufficient privileges".
I can't figure out why. To summarise: