Database Administration (MOSC)

MOSC Banner

Unified auditing: Remove a privilege from ORA_SECURECONFIG

I have recently granted privilege EXEMPT ACCESS POLICY to some users.

I haven't noticed that this was creating AUDIT records. It ended filling up my SYSAUX tablespace.

I do not know how the new auditing works.

However I managed to find the below query:

SELECT *

FROM  audit_unified_policies

WHERE policy_name in ('ORA_SECURECONFIG')

ORDER BY audit_option;

I see that the privilege EXEMPT ACCESS POLICY is being audited.

How can I stop or disable or remove the EXEMPT ACCESS POLICY from ORA_SECURECONFIG?

Thanks

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