This content has been marked as final. Show 3 replies
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 :(