ADMIN_HashPassword

Show allHide all

Deprecated. Don't use for new development and try to migrate existing uses.

Type: Scalar function

Computes a hash from a password and salt, using the SHA-512 algorithm.

If you need to test a Softadmin®-user's password then you should use ADMIN_User_Authenticate, but you can use ADMIN_HashPassword when you have passwords in your own tables.

Parameters

@Password mandatory nvarchar(8000)
The password
@Salt mandatory varbinary(8000)
Salt to append to password. You should use a dedicated random salt, for example created by ADMIN_User_CreatePasswordSalt, rather than an integer-primary-key column or something similarly short and predicatble.