Re: URGENT:Logging in oracle server

From: Sean Fitzgerald <sfitzgerald_at_centurytel.net>
Date: Sat, 03 Aug 2002 13:46:23 -0400
Message-ID: <3D4C16EF.3030203@centurytel.net>

Unless auditing was specifically turned on and configured prior to this, there is not an audit trail. You don't mention a version or platform but if you have 8i or greater, you can use log miner to view your redo log information and potentially track down the user.

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?
>
Received on Sat Aug 03 2002 - 12:46:23 CDT