Files
server/util/Migrator/DbScripts/2026-03-16_00_AlterReadKdfByEmail.sql
Ike 1bc5f4ec1e [PM-21926] [PM-30350] [PM-32389] Read salt from database (#7230)
feat: add MasterPasswordSalt to database responses and DTOs

- Add Dapper migration scripts and update SQL project
- Include MasterPasswordSalt in database response models and DTOs
- Add null coalescing to User entity for MasterPasswordSalt
- Update EF queries to return MasterPasswordSalt
- Rename migrations for consistency
- Add test coverage for affected repositories
- Update EmergencyAccessTakeOverResponseModel tests
2026-03-18 16:18:16 -04:00

19 lines
307 B
Transact-SQL

CREATE OR ALTER PROCEDURE [dbo].[User_ReadKdfByEmail]
@Email NVARCHAR(256)
AS
BEGIN
SET NOCOUNT ON
SELECT
[Kdf],
[KdfIterations],
[KdfMemory],
[KdfParallelism],
[MasterPasswordSalt]
FROM
[dbo].[User]
WHERE
[Email] = @Email
END
GO