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.

Other related posts: