Grant on underlying tables for view
407258Mar 11 2004 — edited Aug 11 2009i have a query that can i give grant on a view and would be able to select data from the view without giving the grant on the underlying tables. Say i have 2 tables in my schema 'schema1', 'emp' and 'dept' and create a view 'view1' on these tables. Now, if i give a grant on the view 'view1' like this to the other schema 'schema2' like this:
grant select on view1 to schema2
where schema2 is the other schema. Then, will the select in the other schema, 'schema2' like this work:
select * from schema1.view1
without giving the select on 'emp' & 'dept' first to 'schema2'. Please help in solving my doubt as i need it resolved urgently.