DDL触发器
来源:互联网 发布:淘宝如何找客户 编辑:程序博客网 时间:2024/05/20 20:22
create or replace trigger tr_ddl
before ddl on database
declare
l_errmsg varchar2(100) := '对不起,你无权修改';
begin
if (Ora_dict_obj_type = 'TABLE' or Ora_dict_obj_type='INDEX' or Ora_dict_obj_type='PROCEDURE' or Ora_dict_obj_type='TRIGGER') AND
/*(ora_dict_obj_owner ='NCCMOLTP_HNS' or ora_dict_obj_owner='NCCMHIST_HNS') and*/ ora_login_user not in ('SYS', 'SYSTEM') and
(Ora_sysevent = 'ALTER' OR Ora_sysevent = 'DROP' OR Ora_sysevent = 'CREATE') then
raise_application_error(-20001,
ora_dict_obj_owner || '.' || ora_dict_obj_name || ' ' ||
l_errmsg);
end if;
/* if (Ora_dict_obj_type = 'TRIGGER' ) AND
(ora_dict_obj_owner ='NCCMOLTP_HNS' or ora_dict_obj_owner='NCCMHIST_HNS') and ora_login_user not in ('SYS', 'SYSTEM') and
(Ora_sysevent = 'ALTER' OR Ora_sysevent = 'DROP' or Ora_sysevent = 'CREATE') then
raise_application_error(-20001,
ora_dict_obj_owner || '.' || ora_dict_obj_name || ' ' ||
l_errmsg);
end if;*/
exception
when no_data_found then
null;
end;
before ddl on database
declare
l_errmsg varchar2(100) := '对不起,你无权修改';
begin
if (Ora_dict_obj_type = 'TABLE' or Ora_dict_obj_type='INDEX' or Ora_dict_obj_type='PROCEDURE' or Ora_dict_obj_type='TRIGGER') AND
/*(ora_dict_obj_owner ='NCCMOLTP_HNS' or ora_dict_obj_owner='NCCMHIST_HNS') and*/ ora_login_user not in ('SYS', 'SYSTEM') and
(Ora_sysevent = 'ALTER' OR Ora_sysevent = 'DROP' OR Ora_sysevent = 'CREATE') then
raise_application_error(-20001,
ora_dict_obj_owner || '.' || ora_dict_obj_name || ' ' ||
l_errmsg);
end if;
/* if (Ora_dict_obj_type = 'TRIGGER' ) AND
(ora_dict_obj_owner ='NCCMOLTP_HNS' or ora_dict_obj_owner='NCCMHIST_HNS') and ora_login_user not in ('SYS', 'SYSTEM') and
(Ora_sysevent = 'ALTER' OR Ora_sysevent = 'DROP' or Ora_sysevent = 'CREATE') then
raise_application_error(-20001,
ora_dict_obj_owner || '.' || ora_dict_obj_name || ' ' ||
l_errmsg);
end if;*/
exception
when no_data_found then
null;
end;
0 0
- DDL触发器
- DDL触发器
- DDl触发器
- DDL触发器
- Oracle触发器3-DDL触发器
- 设计DDL触发器
- DDL触发器学习整理
- SQL DDL触发器
- DDL 触发器 1
- DDL 触发器 2
- SqlServer DDL 触发器
- Oracle DDL 触发器
- DDL触发器的应用
- 创建DDL触发器
- Oracle12--DDL触发器(五十七)
- DML 触发器、DDL 触发器和登录触发器
- 利用Oracle DDL触发器实现DDL监控
- MS SQL Server:DDL 触发器....
- C++ STL中哈希表 hash_map介绍
- 2017研究生准考证打印入口下载 操作图解
- SVM熟练到精通4:偏离点与松弛变量
- android进程间通信的选择
- 为什么mysql事务回滚后, 自增ID依然自增
- DDL触发器
- 前后台交互—Model后台传到前台
- bzoj 1497: [NOI2006]最大获利-----------算法模板[最大权闭合子图]&省选计划系列
- ICE入门之hello world
- Tomcat server.xml配置详解(转载地址)
- indexerror: too many indices for array
- ionic添加cordova插件-SMS
- NSDecimalNumber学习记录
- [Mapbox GL]创建悬停效果