6. Implementing Security Auditing : Security Alarms : How to Implement a Security Alarm
 
Share this page                  
How to Implement a Security Alarm
To implement a security alarm, follow these basic steps:
1. Create the security alarm. Issue the CREATE SECURITY_ALARM statement to define the conditions that will trigger the alarm. For example:
CREATE SECURITY_ALARM ON TABLE employees IF FAILURE;
(In VDBA, use the appropriate Security Alarm branch in the Database Object Manager window.)
2. Have an authorized user issue the ENABLE SECURITY_AUDIT ALARM statement to enable auditing of security alarms. You can also use ENABLE SECURITY_AUDIT (see Security Auditing) to specify other types of auditing.
When user access to the specified database or table triggers the alarm, a record is written to the audit log and the associated database event, if any is defined, is raised.
To drop a security alarm
1. Issue a HELP SECURITY_ALARM statement to obtain the security alarm number. For example:
HELP SECURITY_ALARM employees;
Security alarms on employees are:
Security alarm 2:
create security_alarm on table employees if failure
2. Issue a DROP SECURITY_ALARM statement. For example:
DROP SECURITY_ALARM ON employees 2;