SQL Language (MOSC)

MOSC Banner

VIEW Permissions

edited Jul 24, 2013 3:49AM in SQL Language (MOSC) 4 commentsAnswered ✓
I am creating a new view that uses 3 different schema owners.  Creating the view works fine I can select the view fine using the schema owner that created it but when I try and select the view with another privileged user it gives me ORA-01031: insufficient privileges.

I can take that same user and query every table that makes up the query just fine.  I can copy the entire query for the view and run it as the user but when I try to run the new view I get the 01031 error.  I granted SELECT on the new view to the user and the user still can’t return rows.  I can do a describe of the view using the user and it will show me everything about the view but will not let me see the data.

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