Problem with an audit policy - ORA-46368
Hi,
I want to create a policy but I get the following error and I don't see the problem?
create audit policy "testpolicy" actions logon WHEN 'NOT((SYS_CONTEXT(''USERENV'',''HOST'')=''test'' AND SYS_CONTEXT(''USERENV'',''CLIENT_PROGRAM_NAME'') LIKE ''TEST%''))' evaluate per session
*
ERROR at line 1:
ORA-46368: Audit policy does not have a simple rule condition.
but this works:
SQL> create audit policy "testpolicy" actions logon WHEN 'NOT((SYS_CONTEXT(''USERENV'',''HOST'')=''test'' AND SYS_CONTEXT(''USERENV'',''CLIENT_PROGRAM_NAME'') = ''TEST%''))' evaluate per session;
Audit policy created.
What is wrong?
thx T-1000