Re: logging who connects

I've always been quite keen on setting audit_trail=db in the init.ora, then doing audit connect (or audit session).

The results show up in dba_audit_session.

You have to remember to clear sys.aud$ from time to time, and it is quite sensible to rebuild it in a non-system tablespace before you start anyway.

Version 8.0.4:

SQL> desc dba_audit_session

 Name                            Null?    Type
 ------------------------------- -------- ----
 OS_USERNAME                              VARCHAR2(255)
 USERNAME                                 VARCHAR2(30)
 USERHOST                                 VARCHAR2(128)
 TERMINAL                                 VARCHAR2(255)
 TIMESTAMP                       NOT NULL DATE
 ACTION_NAME                              VARCHAR2(27)
 LOGOFF_TIME                              DATE
 LOGOFF_LREAD                             NUMBER
 LOGOFF_PREAD                             NUMBER
 LOGOFF_LWRITE                            NUMBER
 LOGOFF_DLOCK                             VARCHAR2(40)
 SESSIONID                       NOT NULL NUMBER
 RETURNCODE                      NOT NULL NUMBER
 SESSION_LABEL                            RAW MLSLABEL

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Daniel Fong wrote in message <377A67F1.FC3309D8_at_ilog.com>...
>Hello,
>
>Is there away to get Oracle to log who connects and from where?
>Thanks.
>
>-Dan
>
Received on Thu Jul 01 1999 - 16:24:32 CDT