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

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Thu, 22 Nov 2012 18:09:12 +0800
Message-ID: <CAMNBsZtG2fDsLUo=X34pe8ho3eCTwXXVGFdE35GcjM3s1QzDBg_at_mail.gmail.com>



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


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 22 2012 - 11:09:12 CET

Original text of this message