spMFInsertUserAccount

Signature

EXEC dbo.spMFInsertUserAccount
    @Doc = N'<xml>',
    @isFullUpdate = 1,
    @Output = NULL OUTPUT,
    @Debug = 0;

Returns

INT: 1 on success; -1 on error.

Parameters

@Doc

• Type: NVARCHAR(MAX)

• Required: Yes

• Description: Listing of user accounts (XML).

@isFullUpdate

• Type: BIT

• Required: Yes (always 1)

• Description: Full update flag.

@Output

• Type: INT

• Required: No (OUTPUT)

• Description: Update result.

@Debug

• Type: SMALLINT

• Required: No (default = 0)

• Description: Debug level. - 1 = Standard Debug Mode

Purpose

The purpose of this procedure is to insert user account details into MFUserAccount table.

Changelog

Date	Author	Description
2024-05-23	LC	Fix bug for updating user account changes
2023-10-12	LC	Update to insert or update changes and set deleted flag for deleted items
2023-05-24	LC	Add vault roles
2019-08-30	JC	Added documentation