Re: Log user/password of fail connection attempts

The password is not available through the audit mechanism. I don't know what use it would be, anyway.

                                    Rick

Thomas Guettler <access_at_thomas-guettler.de> writes:

> 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
>

-- 
                                Rick Wessman
                                Security Assurance Group
                                Oracle Corporation
                                Rick.Wessman_at_oracle.com

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.