Database Security Products (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center