Problem
Prohibit Excel from Connecting to your Database
It could be accidental or not, but sometimes it's helpful, if you can make sure certain tools aren't allowed to connect to a certain database. The following trigger is executed whenever someone wants to create a connection. We then check the program name and raise an exception if it matches with a tool we want to exclude:
Solution
Recipe #1 - Block Excel from Connecting to your Database
CREATE OR REPLACE
TRIGGER block_excel AFTER LOGON ON DATABASE
DECLARE
prog_ sys.v_$session.program%TYPE;
BEGIN
SELECT UPPER(program) INTO prog_
FROM sys.v_$session
WHERE audsid = USERENV('SESSIONID')
AND audsid != 0;
IF prog_ LIKE '%EXCEL%' THEN
RAISE_APPLICATION_ERROR(-20000, 'You are not allowed to connect to this database using Excel!');
END IF;
END;
Comments