Website.ChangePassword
Documentation | WideWorldImporters |
Schema | Website |
Name | ChangePassword |
Input/Output
Mode | Name | Data type | Description | |
---|---|---|---|---|
1 | IN | PersonID | int | |
2 | IN | OldPassword | nvarchar(40) | |
3 | IN | NewPassword | nvarchar(40) |
Script
CREATE PROCEDURE Website.ChangePassword @PersonID int, @OldPassword nvarchar(40), @NewPassword nvarchar(40) WITH EXECUTE AS OWNER AS BEGIN SET NOCOUNT ON; SET XACT_ABORT ON; UPDATE [Application].People SET IsPermittedToLogon = 1, HashedPassword = HASHBYTES(N'SHA2_256', @NewPassword + FullName) WHERE PersonID = @PersonID AND PersonID <> 1 AND HashedPassword = HASHBYTES(N'SHA2_256', @OldPassword + FullName); IF @@ROWCOUNT = 0 BEGIN PRINT N'The PersonID must be valid, and the old password must be valid.'; PRINT N'If the user has also changed name, please contact the IT staff to assist.'; THROW 51000, N'Invalid Password Change', 1; RETURN -1; END; END; |
Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51