Re: Understanding DBA_AUDIT

From: LW <ypwitkow_at_nospamcyf-kr.edu.pl>
Date: Mon, 5 May 2003 11:29:00 +0000 (UTC)
Message-ID: <b95hts$1b4$1@srv.cyf-kr.edu.pl>

Marcin <mwolski_at_poczta.fm> wrote:

> TIMESTAMP
> Timestamp for the creation of the audit trail entry or login time for the
> CONNECT statement
> ACTION_NAME
> Name of the action type corresponding to the numeric code in the ACTION
> column in DBA_AUDIT_TRAIL
> LOGOFF_TIME
> Timestamp for user log off

> So, We've got
> USERNAME TIMESTAMP | ACTION_NAME
> LOGOFF_TIME | RETURNCODE
> SCOTT 30-04 09:04:29 LOGOFF
> 30-04 09:04:31 0

> And is it means, that scott logged off at 30-04 09:04:31 and the record was
> written to the audittrail at 30-04 09:04:29??

Yes. Scott logged on at 30-04 09:04:29 (and the record was written) and logged off at 30-04 09:04:31 (and the record was updated).

Best,
LW Received on Mon May 05 2003 - 06:29:00 CDT

Re: Understanding DBA_AUDIT_SESSION