From: dc <card01@pop.cng2.hydro.qc.ca>
Subject: Re: want to log all transaction made
Date: 2000/07/07
Message-ID: <39662172.5D3494CF@pop.cng2.hydro.qc.ca>#1/1
Content-Transfer-Encoding: 8bit
References: <3965E7F5.89D8391D@igs.inter-gate.co.jp>
X-Accept-Language: fr
Content-Type: text/plain; charset=iso-8859-1
X-Trace: carnaval.risq.qc.ca 962994694 204.19.71.2 (Fri, 07 Jul 2000 14:31:34 EDT)
Organization: IREQ http://www.ireq.ca/
MIME-Version: 1.0
Reply-To: caron.denis@hydro.qc.ca
NNTP-Posting-Date: Fri, 07 Jul 2000 14:31:34 EDT
Newsgroups: comp.databases.oracle.server


For the "i want to at least be able to get a log of who logged in as who,
and when to the oracle server" part, I suggest that you audit sessions.
After that, all you have to do is query the aud$ table via the
dba_audit_session view.

I do it here and it's the fastest way to know who loged in when. All that
can be queried naturally via SQL Plus as you wanted.

As far as knowing what the users/developpers are doing, go with the trace as
already mentioned to you.

Hope it helps.


Kyoichi Ozaki a écrit :

> hi all,
>
>   i'm running Oracle8.0.5 server for linux, and i'm the dba. but there's
> been few
> problems with our system on it, with few developers working on the
> server.
> (php3, sql*plus , etc)
>  and i want to track who's executing what (SQL lines).
>  is this possible ?
>  or is there another solution?
>
>  i want to at least be able to get a log of who logged in as who, and
> when to
> the oracle server.( by sqlplus or win2000access )
>
>  thanks,
>
> Kyoichi Ozaki