I have two schemas: A and B.
A has one table with the name 'TEST'. B has created a view 'BASE' which does select on table 'TEST'.
Now I create another user C to which I grant, select on the view 'BASE'.
When the user C runs the following statement, he gets insufficient privileges error:
select * on B.BASE;
What privileges is required to select the contents of the view?