SQL Language (MOSC)

MOSC Banner

Unable to select from View. Select granted to Role

edited Dec 15, 2017 4:03AM in SQL Language (MOSC) 4 commentsAnswered

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:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center