This content has been marked as final. Show 3 replies
The user needs SELECT on the view.
ALL_VIEWS shows the views that the user owns or has access to. Since it isn't listed the user doesn't have SELECT privilege on it.
it seems the user doesnt have the select privileges on the view.
As per the concept of the view eventhough you have privilges to access the underlying tables, if you doesnt have select on view you cannot access the view.
Tried to grant SELECT on view but it complained of one of the tables.
Turns out that when you grant to a view it tries to grant access to the tables underneath but it doesn't check if they already have the privileges~
I granted select access to 3 tables but the user with the view (in a different schema) needed select WITH GRANT OPTION privilege; it didn't matter that the user I was granting view access to already had select on the 3 tables :(