Was this helpful?
DROP SECURITY_ALARM
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The DROP SECURITY_ALARM statement deletes security alarms for a table, database, or current installation.
The DROP SECURITY_ALARM statement has the following format:
[EXEC SQL] DROP SECURITY_ALARM ON [TABLE] tablename |
             DATABASE dbname | CURRENT INSTALLATION | ALL |
               integer {, integer} | alarm_name {, alarm_name}
ALL
Deletes all security alarms for the specified table, database, or current installation.
integer (, integer)
Deletes the security alarms identified by the specified numeric ID. To see the numeric ID, use the HELP SECURITY_ALARM statement.
alarm_name (, alarm_name)
Deletes the security alarms identified by the specified alarm name.
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_AUTI
HELP SECURITY_ALARM
Last modified date: 11/28/2023