记录数据库登陆用户信息:
CREATE or REPLACE TRIGGER LogonTrigger
AFTER LOGON ON DATABASE
BEGIN
if length(SYS_CONTEXT('USERENV','TERMINAL'))>0 then
insert INTO AccountConnections
(TERMINAL,
UserName,
SID,
ISDBA,
HOST,
OS_USER,
IP_ADDRESS,
EventAction,
EventDate)
VALUES
(SYS_CONTEXT('USERENV', 'TERMINAL'),
SYS_CONTEXT('USERENV', 'SESSION_USER'),
SYS_CONTEXT('USERENV','SESSIONID'),
SYS_CONTEXT('USERENV', 'ISDBA'),
SYS_CONTEXT('USERENV', 'HOST'),
SYS_CONTEXT('USERENV', 'OS_USER'),
SYS_CONTEXT('USERENV', 'IP_ADDRESS'),
'LOGIN',
sysdate);
end if;
AFTER LOGON ON DATABASE
BEGIN
if length(SYS_CONTEXT('USERENV','TERMINAL'))>0 then
insert INTO AccountConnections
(TERMINAL,
UserName,
SID,
ISDBA,
HOST,
OS_USER,
IP_ADDRESS,
EventAction,
EventDate)
VALUES
(SYS_CONTEXT('USERENV', 'TERMINAL'),
SYS_CONTEXT('USERENV', 'SESSION_USER'),
SYS_CONTEXT('USERENV','SESSIONID'),
SYS_CONTEXT('USERENV', 'ISDBA'),
SYS_CONTEXT('USERENV', 'HOST'),
SYS_CONTEXT('USERENV', 'OS_USER'),
SYS_CONTEXT('USERENV', 'IP_ADDRESS'),
'LOGIN',
sysdate);
end if;