Re: PUBLIC grants
- From: rjamya <rjamya@xxxxxxxxx>
- To: AVerma@xxxxxxx
- Date: Fri, 2 Jun 2006 06:58:51 -0400
sqlplus /nolog
connect / as sysdba
create view user_to_block.table_to_block as select * from
owner.table_to_block where 1=2;
wouldn't that work? unless of course user_to_block accesses all
objects prefixed with object_owner, then you are hosed ... well
perhaps not, you can use VPD to still apply 1=2 dynamically too.
so, there you go, two solutions.
Raj
--
//www.freelists.org/webpage/oracle-l
Other related posts:
