CREATE TABLE con_audit (
  logintime TIMESTAMP DEFAULT SYSTIMESTAMP,
  username VARCHAR2(30),
  program VARCHAR2(64),
  machine VARCHAR2(64),
  session_id NUMBER,
  action VARCHAR2(10) 
);
-- Trigger to track connections 
CREATE OR REPLACE TRIGGER con_audit_trigger
AFTER LOGON ON DATABASE
BEGIN
  INSERT INTO con_audit (username, program, machine, session_id, action)
  VALUES (USER, SYS_CONTEXT('USERENV', 'MODULE'),
          SYS_CONTEXT('USERENV', 'HOST'),
          SYS_CONTEXT('USERENV', 'SID'), 'CONNECT');
  COMMIT;
END;
/