Hello all
I am having some problems properly understanding the intent of the "index" statement type on the dbms_rls.add_policy procedure. My tests indicate that table_owner can create indexes just fine even if table_owner is prevented (by vpd) from selecting any rows from the table under vpd. Whether index is included in statement_types does not seem to make any difference.
A sql trace shows that a full table-scan of the table does indeed occur as a result of the index operation.
Db version is 12.1.0.2 on Windows 2012 x64.
Can anyone enligthen me?
Regards Niels Jespersen