When selecting from a view ORA-01031: insufficient privileges
As DBA I have granted select privileges on a view to a user, but whenever I login as that user and try to select from the view I get the message 'ORA-01031'. When I run the query in the view as the user I do not have problem and can see the results. This view joins tables from more than one schema and does a distinct on the resultset. The user has select permission on the view and a default role that has reference on all the objects on the other schemas. Schema owner of the view has SELECT privileges on all the tables from other schemas referenced in the view.