Database Security Products (MOSC)

MOSC Banner

Blocking Oracle access by tools to specific users

edited Nov 27, 2015 2:37PM in Database Security Products (MOSC) 20 commentsAnswered ✓
Hi

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center