Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Are failed login attempts logged anywhere?

flying_penguinJun 25 2008 — edited Jun 25 2008

DB version:10gR2
We had an issue where an User account was locked for an hour. Is there a way i could find the machine(ip address/terminal) from where the login was attempted?

It is not in alert log. I just checked it. Queries on v$session will only give the sessions which are connected(like the query below)

SELECT SID,SERIAL#,osuser,TERMINAL FROM V$SESSION WHERE schemaname='SCOTT';

Is there a way to find this out?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 23 2008

Added on Jun 25 2008

#general-database-discussions

7 comments

4,926 views