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