CREATE OR REPLACE TRIGGER save_our_db_tablespace
BEFORE drop
ON database
BEGIN
IF ora_dict_obj_type IN ('TABLESPACE') AND (sys_context('USERENV', 'HOST') not IN ('paynode1','paynode1')) THEN
raise_application_error(num => -20001, msg => 'you can not allow to DROP TABLESPACE ' || ora_dict_obj_name || '!');
END IF;
END ;
/
BEFORE drop
ON database
BEGIN
IF ora_dict_obj_type IN ('TABLESPACE') AND (sys_context('USERENV', 'HOST') not IN ('paynode1','paynode1')) THEN
raise_application_error(num => -20001, msg => 'you can not allow to DROP TABLESPACE ' || ora_dict_obj_name || '!');
END IF;
END ;
/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22392018/viewspace-709958/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Oracle 禁止删除用户
请登录后发表评论
登录
全部评论
