ConvertContactToUser
Convert an existing contact to a user.
Stored Procedures Specific Information
Process of converting contact to user
This stored procedure converts an existing contact to a user. The required parameters ContactId, ContactUsername, ContactPassword, and RoleName each accept a single value. Optional parameters include AccountStatus (accepts 'Active', 'Inactive', or 'Deleted'), MustChangePassword, CanChangePassword, PasswordExpires, and Permissions, each accepting a single value. For example:
EXEC ConvertContactToUser ContactId = 'd444d1ac-fd29-42ba-8635-4d484f62c821', RoleName = 'Standard', ContactUsername = '[email protected]', ContactPassword = 'P1a@df!';
Input
| Name | Type | Description |
| ContactId | String | The unique identifier (id) for the contact to convert. |
| ContactUsername | String | A unique login id for the new user. |
| ContactPassword | String | The password used to login. |
| RoleName | String | The role name to assign to the user. |
| AccountStatus | String | The status of the user account.
The allowed values are Active, Inactive, Deleted. |
| MustChangePassword | Boolean | Whether the user must change their password on next login. |
| CanChangePassword | Boolean | Whether the user is allowed to change their password. |
| PasswordExpires | Boolean | Whether the user's password expires. |
| Permissions | String | A JSON aggregate of permissions to assign to the user. |
Result Set Columns
| Name | Type | Description |
| Id | String | The unique identifier of the newly created user. |
| Username | String | The login username of the newly created user. |
| Role | String | The role assigned to the newly created user. |
| DisplayName | String | The display name of the newly created user. |
| String | The email address of the newly created user. | |
| FirstName | String | The first name of the newly created user. |
| LastName | String | The last name of the newly created user. |
| LastLogOnDate | Datetime | The date and time the user last logged on. |
| UserStatus | String | The status of the newly created user |
| Status | String | Stored Procedure Execution Status |