This project has moved. For the latest updates, please go here.
1
Vote

Create user_sp functions

description

Create user management store procedure functions.

Update the IIdentityService to use stored procedure instead of LINQ to SQL direct calls. This will be faster and remove the need to conflict checking.

Functions:

sp_authenticate(username, passwordhash)
sp_tfa_authenticate(username, passwordhash, tfaSecret)

Function should :
  • Increment InvalidLoginAttempts if the credentials are invalid
  • Set LockoutEnabled to true if InvalidLoginAttempts exceeds the maximum failed login attempts
  • Set updatedTime/updatedBy to system and current timestamp
  • Throw exception if invalid credentials passed
  • Throw exception if account is locked out or obsolete

comments