Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2014
    Posts
    1

    Unanswered: Falied Login attempts

    Hi,

    I am new to sybase and I need help with few things.

    I need to find failed login attempts for an user before successful login.
    Wherever I Search I get only about Setting Maximum failed logins.

    I need to know the number of attempts the user made before successfull login.

    And I would also like to know how to check the code of system procedures.
    sp_helptext but I dont see any output in result area, I just the EXecution time

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    You can setup Auditing to monitor login attempts. The Sybase documentation has an extensive chapter on how to install and configure auditing.
    I'm not crazy, I'm an aeroplane!

  3. #3
    Join Date
    Nov 2014
    Posts
    1
    Hi Sunil,

    First set maximum failed login (say 10) after that try wrong password 2-3 times...then again login with proper password.
    execute with "sp_displaylogin loginname" it will show current failed login attempts.

    To display code of system stored procedure exec the following :
    1>use sybsystemprocs 2>go
    1>sp_helptext "stored procedurename" 2>go



    Quote Originally Posted by SunilKadiwal View Post
    Hi,

    I am new to sybase and I need help with few things.

    I need to find failed login attempts for an user before successful login.
    Wherever I Search I get only about Setting Maximum failed logins.

    I need to know the number of attempts the user made before successfull login.

    And I would also like to know how to check the code of system procedures.
    sp_helptext but I dont see any output in result area, I just the EXecution time

  4. #4
    Join Date
    Feb 2012
    Posts
    133
    you can query master..syslogins and look for logincount column.
    that indicate failed login attempts of the user and reset back to zero once successful login has been made.

    hope might help.

Tags for this Thread

Posting Permissions

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