Database Administration (MOSC)

MOSC Banner

Can one combine audit conditions in unified audit policy

edited Jul 17, 2020 5:04AM in Database Administration (MOSC) 8 commentsAnswered ✓

Hi,

I wonder if one can combine an audit condition when creating a audit policy.

I need to audit proxy users connects except those with a specific os_username.

The documentation of "create audit policy" describes that one can use

Numeric functions: BITAND, CEIL, FLOOR, POWER

Character functions returning character values: CONCAT, LOWER, UPPER

Character functions returning number values: INSTR, LENGTH

Environment and identifier functions: SYS_CONTEXT, UID

Comparison conditions: =, !=, <>, <, >, <=, >=

Logical conditions: AND, OR

Null conditions: IS [NOT] NULL

[NOT] BETWEEN condition

[NOT] IN condition

my policy looks like:

create audit policy mp_proxy_pol_2

actions all

when 'SYS_CONTEXT(''USERENV'', ''PROXY_USER'') IS NOT NULL

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