Triggers 授權

CREATE OR REPLACE TRIGGER SYS.audit_TRI_NO_DROP
BEFORE DROP
ON DATABASE
BEGIN
 
  IF ora_dict_obj_type IN ('TABLE')
   
     AND ((USER NOT IN ('SYS','SYSTEM')) AND USER IN ('EAI','MKT','SCM_ADMIN','OMS','SCM','QUEST','SCM_ADMIN','TMS','WMS'))
   
     AND 1 = 1 THEN
    raise_application_error(num => -20001,
                            msg => '不允許對表' || ora_dict_obj_name ||
                                   '進行刪除!');
  END IF;
END;