create or replace trigger LOGON
after logon on database
begin
   insert into bob.logtable(sesid,userid, machine, logintime)
   values(userenv('SESSIONID'),user,userenv('TERMINAL'),sysdate);
end;