5times validation

Nandha Kumar Nagarajan

7y720

hi friends

i dont know how to write a query help me

when user enter wrong password 5 times is wiill be locked

sp below

ALTER PROCEDURE CHK_UNAME_PASS

(

@UNAME VARCHAR(100),@PASS VARCHAR(100)

)

BEGIN

SET NOCOUNT ON;

IF EXISTS(SELECT *FROM TBL_LOGIN WHERE USERNAME= @UNAME AND PASWORD=@PASS)

PRINT 'LOGIN SUCCESFULLY'

ELSE

BEGIN

PRINT 'INCORRECT USERNAME OR PASSWORD'

END

EXECUTE CHK_UNAME_PASS @UNAME='NANDHA',@PASS='101';

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanwar Ranwa7y ago
Accepted answer
Check this proc
CREATE  PROCEDURE [dbo].[GetCBLoginInfo]
    @UserName VARCHAR(20),
    @Password varchar(20)
AS
SET NOCOUNT ON
Declare @Failedcount AS INT
SET @Failedcount = (SELECT LoginFailedCount from CBLoginInfo WHERE UserName = @UserName)

IF EXISTS(SELECT * FROM CBLoginInfo WHERE UserName = @UserName)

BEGIN

IF EXISTS(SELECT * FROM CBLoginInfo WHERE UserName = @UserName AND Password = @Password )
    SELECT 'Success' AS UserExists
ELSE

Update CBLoginInfo set  LoginFailedCount = @Failedcount+1  WHERE UserName = @UserName

Update CBLoginInfo set LastLoginDate=GETDATE()  WHERE UserName = @UserName
BEGIN
IF @Failedcount >=5


SELECT 'Maximum Attempt Reached (5 times) .Your Account is locked now.' AS UserExists
ELSE

select CONVERT(varchar(10), (SELECT LoginFailedCount from CBLoginInfo   WHERE UserName = @UserName))   AS UserFailedcount
END
END
ELSE

BEGIN

SELECT 'User Does not Exists' AS UserExists
END
+2
Nandha Kumar Nagarajan7y ago
after that when user enter first time login its will display change a password
i need a query
sirrr
0