Database Administration (MOSC)

MOSC Banner

Unified auditing: drop policy doesn't work

Oracle 19c Standard Edition 2:

I cannot drop the policy foestest.

I tried:

noaudit policy foetest;

---> Noaudit erfolgreich. (successfull)

DROP audit POLICY foetest;

--->

Fehler beim Start in Zeile: 14 in Befehl -

DROP audit POLICY foetest

Fehlerbericht -

ORA-46361: Audit-Policy kann nicht gelöscht werden, weil sie aktuell aktiviert ist.

46361. 00000 - "Audit policy cannot be dropped as it is currently enabled."

*Cause:   An attempt was made to drop the audit policy which is currently enabled.

*Action:  Disable the audit policy before dropping.


Why?

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