Drop Security_Alarm

Valid in: SQL, ESQL

The Drop Security_Alarm statement deletes one or more security alarms for the specified table. To create security alarms, use the create security_alarm statement. To display the security alarms defined for a table, use the help security_alarm statement.

The Drop Security Alarm statement allows alarms to be dropped by name or by numeric ID, and to allow alarms on a database or installation to be specified. (To see the numeric ID, use the help security_alarm statement.) To drop all security alarms defined for a table, specify all.

Syntax

The Drop Security Alarm statement has the following format:

[EXEC SQL] DROP SECURITY_ALARM ON [TABLE] table_name |DATABASE
               dbname | CURRENT INSTALLATION
ALL | integer | alarmname {, integer | alarmname}

Embedded Usage

You cannot use host language variables in an embedded Drop Security_Alarm statement.

Permissions

You must be the owner of the tables. To drop database or installation security alarms, you must have security privilege and be connected to the iidbdb.

Locking

The Drop Security_Alarm statement locks the tables on which the security alarms were created, and the iirelation, iiqrytext, and iiprotect system catalogs.

Related Statements

Disable Security_Audit

Create Security_Alarm

Enable Security_Audit

Examples: Drop Security_Alarm

The following are Drop Security_Alarm statement examples:

1. Delete a security alarm for the employee table.

   drop security_alarm employee 1;

2. Drop a table security alarm and an installation alarm.

   drop security_alarm on emp 2;
   drop security_alarm on current installation bad_update ;