create or replace trigger login_audit_trig
  after logon on database
declare
  v_cnt number;
  p_cnt number;
begin
  select COUNT(*) 
    into v_cnt 
    from v$session where audsid = USERENV('sessionid') and upper(program) ='BUSOBJ.EXE';
  select count(*)
    into p_cnt
    from lc_monitor.authorize_users_tab a
   where upper(a.user_id) = upper(ora_login_user)
     and upper(a.osuser_id) in
         (select upper(osuser) from v$session where audsid = USERENV('sessionid'));
  if v_cnt > 0 then
    insert into lc_monitor.login_audit
    (user_id,user_sid,user_serial,login_date,osuserid,machinename,program) 
    select user,
           sid,
           serial#,
           logon_time,
           osuser,
           machine, 
           program  
           from v$session 
    where audsid= USERENV('sessionid')
    and user not in ('DBSNMP','SYS','PERFSTAT');
  else if p_cnt > 0 then 
    insert into lc_monitor.login_audit
    (user_id,user_sid,user_serial,login_date,osuserid,machinename,program) 
    select user,
           sid,
           serial#,
           logon_time,
           osuser,
           machine, 
           program  
           from v$session 
    where audsid= USERENV('sessionid')
    and user not in ('DBSNMP','SYS','PERFSTAT');
   else 
    Raise_application_error(-20501,'Error: login using ' || ora_login_user ||' prohibited');
  end if;
  end if;
  commit;
 end;