DROP AUDIT (Delete an audit target event)
Function
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::= {ALIAS authorization-identifier.table-alias |FOREIGN INDEX authorization-identifier.index-identifier |FOREIGN TABLE authorization-identifier.table-identifier |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 |SERVER foreign-server-definition-owner.foreign-server-name |TABLE [authorization-identifier.]table-identifier |TRIGGER authorization-identifier.trigger-identifier |TYPE authorization-identifier.data-type-identifier |USER MAPPING SERVER foreign-server-name |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"