Block developers from using TOAD and other tools on production databases
来源:互联网 发布:红色警戒mac版下载 编辑:程序博客网 时间:2024/05/01 13:40
CONNECT / AS SYSDBA;
CREATE OR REPLACE TRIGGER block_tools_from_prod
AFTER LOGON ON DATABASE
DECLARE
v_prog sys.v_$session.program%TYPE;
BEGIN
SELECT program INTO v_prog
FROM sys.v_$session
WHERE audsid = USERENV('SESSIONID')
AND audsid != 0 -- Don't Check SYS Connections
AND ROWNUM = 1; -- Parallel processes will have the same AUDSID's
IF UPPER(v_prog) LIKE '%TOAD%' OR UPPER(v_prog) LIKE '%T.O.A.D%' OR -- Toad
UPPER(v_prog) LIKE '%SQLNAV%' OR -- SQL Navigator
UPPER(v_prog) LIKE '%PLSQLDEV%' OR -- PLSQL Developer
UPPER(v_prog) LIKE '%BUSOBJ%' OR -- Business Objects
UPPER(v_prog) LIKE '%EXCEL%' -- MS-Excel plug-in
THEN
RAISE_APPLICATION_ERROR(-20000, 'Development tools are not allowed here.');
END IF;
END;
/
SHOW ERRORS
CREATE OR REPLACE TRIGGER block_tools_from_prod
AFTER LOGON ON DATABASE
DECLARE
v_prog sys.v_$session.program%TYPE;
BEGIN
SELECT program INTO v_prog
FROM sys.v_$session
WHERE audsid = USERENV('SESSIONID')
AND audsid != 0 -- Don't Check SYS Connections
AND ROWNUM = 1; -- Parallel processes will have the same AUDSID's
IF UPPER(v_prog) LIKE '%TOAD%' OR UPPER(v_prog) LIKE '%T.O.A.D%' OR -- Toad
UPPER(v_prog) LIKE '%SQLNAV%' OR -- SQL Navigator
UPPER(v_prog) LIKE '%PLSQLDEV%' OR -- PLSQL Developer
UPPER(v_prog) LIKE '%BUSOBJ%' OR -- Business Objects
UPPER(v_prog) LIKE '%EXCEL%' -- MS-Excel plug-in
THEN
RAISE_APPLICATION_ERROR(-20000, 'Development tools are not allowed here.');
END IF;
END;
/
SHOW ERRORS
- Block developers from using TOAD and other tools on production databases
- Defense in Depth using OSSEC and other free tools
- Unique Indexes in MySQL and Other Databases
- kill application from other application on ios 6 using void kill dont work
- Managing Virtual Teams: Getting the Most from Wikis, Blogs, and Other Collaborative Tools
- Migrating Databases To and From ASM with
- Docker and Databases - a Hands-on Guide
- Protobuf-C For Embedded Developers (and other cross compilers)
- How SSIS and Other Tools Obtain Metadata
- Debugging with tcpdump and other tools
- Debugging with tcpdump and other tools
- 50 New Resources and Tools for Developers and Designers
- Creating and changing a production order from ABAP.
- Creating and changing a production order from ABAP FUNCTION 'CLOI_CHANGES_UPL_31'
- mysql query to find the maximum 3 values from a column and group by on other column
- Using OpenLDAP with Microsoft SQL Server and Oracle Backend Databases
- Android App Developers GUI Kits, Icons, Fonts and Tools
- 40 Bootstrap Tools and Generators for Web Developers
- sybase powerdesigner 15.1破解方法
- flex_item renderers(项渲染器);
- AssetManager assets文件夹
- Ubuntu 11.10(内核3.0.0.16-generic)升级内核到3.2.9无线网卡驱动问题【图解】
- 用ModelSim仿真FIFO
- Block developers from using TOAD and other tools on production databases
- AspectC++
- MartyrsCemetery菜鸟感想一之Ubuntu下搭建CUDA开发环境
- 自写的非常不错的oracle语句 精选
- Make Table read only
- android错误 Android NAND: nand_dev_load_disk_state,
- 实现RTP协议的H.264视频传输系统
- 2012七种最最为流行的婚纱摄影的风格
- 修改tomcat的conf/server.xml解决网页乱码