Hi,
I'm creating a trigger to audit users with DBA privilege who are using TOAD. In my trigger, I'm trying to return the module but it seems null for TOAD. Trigger was also tested for Sql Developer and it worked fine. Any idea?
CREATE OR REPLACE TRIGGER PRODDBA.LOGON_TRIGGER_TOAD
AFTER LOGON ON DATABASE
DECLARE
v_mod varchar2(64);
BEGIN
select upper(sys_context('userenv','module'))
into v_mod
from dual;
if upper(v_mod) like '%TOAD%'
then
insert
into PRODDBA.LOGON_AUDIT
(
sid,
serial#,
username,
machine,
osuser,
program,
time_stamp
)
values
(
proddba.logon_sid,
proddba.logon_serial,
proddba.logon_username,
proddba.logon_host,
proddba.logon_osuser,
v_mod,
sysdate
);
END IF;
END;
/
By running the query manually, I can see the module.
