Re: Audit user conections

From: Peggy Lok <lokp_at_tdbank.ca>
Date: 1996/04/15
Message-ID: <4kucmk$7gv_at_sam.inforamp.net>#1/1


To start auditing, you need to:

  1. set the parameter 'audit_trail' to true in your init.ora file.
  2. restart your database.
  3. run the script cataudit.sql.
  4. issue the command 'audit session'.

Then you can select from the dba_audit_session table to get all the login information.....

Peggy

Artur Akerman <akermana_at_ix.netcom.com> wrote:

>Is there any way to keep a log of all the users connectiong to the
>database ? We want to monitor database usage...

> Thank you.
> Artur Akerman
> akermana_at_ix.netcom.com
Received on Mon Apr 15 1996 - 00:00:00 CEST

Original text of this message