- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
extend UNIFIED AUDIT policy condition to accept SYSDATE
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
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..