Blocking Oracle access by tools to specific users
I need to prevent specific Oracle users from being used to access the database via Toad, Tora, SQL*Plus but for the application to work on their schemas as usual.
Burleson shows scripts that appear to do this for all logins:
http://www.dba-oracle.com/t_trigger_restrict_end_user_access.htm
TOAD+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