Forum Stats

  • 3,824,848 Users
  • 2,260,430 Discussions


extend UNIFIED AUDIT policy condition to accept SYSDATE

berx Member Posts: 219 Silver Badge
edited Jul 15, 2019 3:56PM in Database Ideas - Ideas

In unified audit policies a WHEN condition can be created to control when the audit policy is enforced.

Right now the audit conditions can be only based on SYS_CONTEXT, UID.

For conditions like Accessing a table between 9 p.m. and 6 a.m. or on Saturday and Sunday also SYSDATE (and to_char) are required.

Right now an attempt like 'to_char(sysdate,''hh24'') not between ''09'' and ''18''' l

eads to ORA-46368: Audit policy does not have a simple rule condition..

Sven W.ctrieb
2 votes

Active · Last Updated