ORA-28115 with EXEMPT ACCESS POLICY privilege

List,

A user USER1 has been granted select, insert, update, delete on all tables of an application schema (USER2) that uses row-level security. The RLS policies cover select, insert, update, and delete, and have check option enabled. USER1 has also been granted EXEMPT ACCESS POLICY system privilege.

Each table in the USER2 schema has a trigger that causes insertion of a row into an audit table whenever DML is performed. When USER1 performs DML on a USER2 table, the operation fails with

ORA-28115: policy with check option violation Cause: Policy predicate was evaluated to FALSE with the updated values.

The error stack shows that the error occurs in the trigger's INSERT into the audit table.

USER2 is able to insert into the audit table directly with no error.

Does EXEMPT ACCESS POLICY not apply to recursive (e.g., motivated by trigger) SQL?

Thanks in advance!

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