Database Administration (MOSC)

MOSC Banner

Unified auditing: drop policy doesn't work

in Database Administration (MOSC) 6 commentsAnswered ✓

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center