Show all Hide all


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.

Type: Scalar function
Area of use: General use


@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.