Re: PUBLIC grants

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
--
http://www.freelists.org/webpage/oracle-l


Other related posts: