I have following scenario, is this possible to oe schema to select only, but not create table/view from hr table?
- table "Employees" created and have data hr schema
- granted read access to oe schema --> grant read on employees to oe;
- connected to oe schema
- create View V_Employees as select * from hr.employees; --- i do not want oe schema create view from my table
- select * from hr.employees; -- this can be allowed
I am expecting OE schema should not be able to create view/table from my hr schema table that granted select/read privilage