Unified audit does not log updates executed inside forall
Hi
Oracle 19.16
SQL> select * from audit_unified_policies where policy_name = 'OKIS_POLICY' and object_name = 'MENETLUSED' order by policy_name, object_schema, object_name;
-- This update will be logged by the policy UPDATE Menetlused SET LoppKP = LoppKP WHERE iD = 6168856; commit; -- This will not be logged with the same policy set serveroutput on; DECLARE TYPE c1 IS RECORD ( id NUMBER ); TYPE t1 IS TABLE OF c1; t t1; BEGIN select 6168857 as id BULK COLLECT INTO t FROM dual; -- Uuendame menetluste küljes andmed FORALL I IN INDICES OF t UPDATE Menetlused SET loppkp = loppkp WHERE ID = t(I).id; dbms_output.put_line('Updated ' || SQL%ROWCOUNT || ' table row.'); commit; END; /
0