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;
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;
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22392018/viewspace-692378/，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle 导出某个用户下的表
下一篇：
GridView合并单元格
请登录后发表评论
登录
全部评论
