Re: URGENT:Logging in oracle server

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 03 Aug 2002 19:09:54 +0200
Message-ID: <pg3okuoo3q3ck124679rakvj50ck6uv06i@4ax.com>

On 3 Aug 2002 09:34:47 -0700, jackie_ol_at_hotmail.com (Jackie) wrote:

>Hi!
>Is there a way to determine who logged on to Oracle server and issued
>sql commands and manipulated database?
>My company's database is badly changed by someone and I want to track
>users who logged on to the server?
>Does oracle log this kind of information?
Without enabling auditing: no
You need to enable auditing changing the audit_trail parameter to db and bouncing the database
and then at least issue

audit connect

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Aug 03 2002 - 12:09:54 CDT