I found one coding on site and i have 2 doubt
The DATABASE is refering to all the database ?
Can I change the word to a Connection Name?
create or replace trigger
logon_audit_tri gger
AFTER LOGON ON DATABASE
BEGIN
insert into stats$user_log values(
user,
sys_context('US ERENV','SESSION ID'),
sys_context('US ERENV','HOST'),
null,
null,
null,
sysdate,
to_char(sysdate , 'hh24:mi:ss'),
null,
null,
null
);
END;
The DATABASE is refering to all the database ?
Can I change the word to a Connection Name?
create or replace trigger
logon_audit_tri gger
AFTER LOGON ON DATABASE
BEGIN
insert into stats$user_log values(
user,
sys_context('US ERENV','SESSION ID'),
sys_context('US ERENV','HOST'),
null,
null,
null,
sysdate,
to_char(sysdate , 'hh24:mi:ss'),
null,
null,
null
);
END;
Comment