ON-LOGON TRIGGER
Hi eveybody,
I am trying to write the "ON LOGON" trigger to monitor the user activities(Logons with time). I have written following code. But it is not compiling. Can you please identify the error?
=================================================
create or replace trigger register_logon
on logon
begin
insert into logon_time
values (Select user, to_char(sysdate, 'DD-MON-RRRR hh:mm:ss') from dual)
end;
=================================================
Regards
Mudassar