DROP AUDIT (Delete an audit target event)
Function
DROP AUDIT deletes definitions that match the target audit event defined in CREATE AUDIT from the targets of auditing.
Privileges
Format
No. | Format |
---|---|
1 | DROP AUDIT |
2 | FOR operation-type |
9 | [selection-option] |
3 | [WHENEVER {SUCCESSFUL | UNSUCCESSFUL | ANY}] |
Details about items
No. | Format |
---|---|
2 | operation-type::= ANY |
9 | selection-option::=ON object-name |
object-name::= {FUNCTION authorization-identifier.routine-identifier |INDEX authorization-identifier.index-identifier |LIST authorization-identifier.table-identifier |PROCEDURE authorization-identifier.routine-identifier |RDAREA RDAREA-name |SCHEMA authorization-identifier |TABLE [authorization-identifier.]table-identifier |TRIGGER authorization-identifier.trigger-identifier |TYPE authorization-identifier.data-type-identifier |VIEW authorization-identifier.table-identifier | |
4 | session-type::= |
5 | privilege-operation-type::= |
6 | object-definition-event-type::= |
7 | object-operation-event-type::= |
8 | utility-event-type::= |
Operands
For details about each item, see CREATE AUDIT (Define the target audit event) in this chapter.
Rules
Notes
Examples
DROP AUDIT FOR ANY
DROP AUDIT FOR SESSION CONNECT
DROP AUDIT FOR PRIVILEGE GRANT
DROP AUDIT FOR DEFINITION CREATE WHENEVER ANY
DROP AUDIT FOR ACCESS INSERT
DROP AUDIT AUDITTYPE ANY FOR ANY
DROP AUDIT AUDITTYPE PRIVILEGE FOR ANY
DROP AUDIT AUDITTYPE EVENT FOR ANY ON TABLE "USER1"."T1"