Does VPD prevent/filter ALTER TABLE MOVE and ALTER INDEX REBUILD commands

  • From: Hemant K Chitale <hemantkchitale@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 22 Nov 2012 18:09:12 +0800

I understand that VPD / RLS adds additional predicates to any query against
designated tables/columns.
However, if a non-SYS schema (e.g. APPS) were to issue ALTER TABLE
schema.tablename MOVE and ALTER INDEX schema.indexname REBUILD commands for
tables/indexes in a third schema (say HR), would those commands be
restricted by the presence of VPD ?

Hemant K Chitale
http://hemantoracledba.blogspot.com
http://hemantscribbles.blogspot.com
http://web.singnet.com.sg/~hkchital


--
//www.freelists.org/webpage/oracle-l


Other related posts:

  • » Does VPD prevent/filter ALTER TABLE MOVE and ALTER INDEX REBUILD commands - Hemant K Chitale