Hi Friends,
I have been searching for Toad for running on my Mac as i was frustrated with blank outs with SQL developer. I came across a wonderful article for running toad on Mac Osx.
http://toadworld.com/Blogs/tabid/67/EntryId/884/Run-Toad-for-Oracle-on-Mac-OS-X.aspx
Thanks,
Ujjwal Soni
Showing posts with label toad. Show all posts
Showing posts with label toad. Show all posts
Friday, May 25, 2012
Thursday, November 18, 2010
Blocking developers from using TOAD and other tools on production databases
Today, I’ve seen a nice example at www.psoug.org on how to prevent users from using additional tools to connect to production database. This is the AFTER LOGON trigger create ON DATABASE as follows:
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
http://www.psoug.org/snippet/Block_TOAD_and_other_tools_516.htm
Cheers!!!
Ujjwal B Soni
Subscribe to:
Posts (Atom)