oracle 触发器实现禁止在数据库中创建dblink ---通过触发器实现

发布时间：2020-12-12 14:16:02 所属栏目：百科来源：网络整理

导读：CREATE OR REPLACE TRIGGER no_create_dblink BEFORE DDL ON DATABASE BEGIN IF ORA_SYSEVENT = 'CREATE' and ORA_DICT_OBJ_TYPE='DATABASE LINK' THEN RAISE_APPLICATION_ERROR (-20000,'Cannot create the ' || ORA_DICT_OBJ_TYPE ||' named ' || ORA_DICT

CREATE OR REPLACE TRIGGER no_create_dblink
BEFORE DDL ON DATABASE
BEGIN
IF ORA_SYSEVENT = 'CREATE' and ORA_DICT_OBJ_TYPE='DATABASE LINK'
THEN
RAISE_APPLICATION_ERROR (-20000,'Cannot create the ' || ORA_DICT_OBJ_TYPE ||' named ' || ORA_DICT_OBJ_NAME ||
' as requested by ' || ORA_DICT_OBJ_OWNER ||'联系管理员');
END IF;
END;
/

验证：
create public database link to_11 connect to scott identified by tiger using 'bylw';
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-20000: Cannot create the DATABASE LINK named TO_11 as requested by
??????????
ORA-06512: at line 4

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!