Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Log user/password of fail connection attempts

Re: Log user/password of fail connection attempts

From: Thomas Guettler <access_at_thomas-guettler.de>
Date: Tue, 11 Dec 2001 10:46:04 +0100
Message-ID: <3C15D5DC.4060405@thomas-guettler.de>

Sybrand Bakker wrote:

> On Mon, 10 Dec 2001 15:41:28 +0100, Thomas Guettler
> <access_at_thomas-guettler.de> wrote:
>
>

>>I have an application which tries to connect to my oracle 8i. But it 
>>fails. How can I log the connection-string this application uses in oracle?
>>
>>I want to know which password and user this application uses. I couldn't 
>> find this information in the application itself.
>>
>>Thank you!
>>

>
>
> enable auditing
> (init<sid>.ora audit_trail parameter needs to be set to the string db
> [without quotes])
>
> then
> audit connect whenever unsuccesful

Thank you! I edited the file and executed the SQL statement and now I get the user name. But unfortunately I don't get the password. Do you know how I could get it?

  Thomas Guettler Received on Tue Dec 11 2001 - 03:46:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US