DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Failed_login_attempts

  1. #1
    Join Date
    Mar 2004
    Location
    India
    Posts
    72

    Failed_login_attempts

    Hi,

    In our one of the Profile, we set FAILED_LOGIN_ATTEMPTS as 5. I want to check how many times user hits the database with wrong password. Before it locks the account, I want to warn the user that only X no of attempts he has..

    Is there any way to count failed login attempts?

    Thanks in advance.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You would probably need to write a trigger to output this information. But it depends on whether the use is using sqlplus, toad, or some Java application. How do the users connect to the database?

  3. #3
    Join Date
    Mar 2004
    Location
    India
    Posts
    72
    The user using some application to login. The problem is whenever the user enters wrong password, the application hits the database two times it seems. Because of that the user account locks at second attempt itself even though I set failed_login_attempts as 3 for their profile.

    I believe that oracle holds the failed login attempt counts and that can be viewed, I am not sure which table/view to query.

    I got into one of the site and they told to query user$, but there is no such view available.

  4. #4
    Join Date
    Apr 2008
    Location
    Bangalore
    Posts
    96
    you should have the permission to view data dictionary.I think the lcount column in user$ will give the failed login attempts

  5. #5
    Join Date
    Mar 2004
    Location
    India
    Posts
    72
    I tried with sys userid, it works.

    Thanks for everyone.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width