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