Skip to main content

Create a new SelectPay Administrator user

Set up a new user in the SelectPay Administrator tool.

C
Written by Charlotte Alderson

To create a new user in the SelectPay Administrator tool, follow the steps below.

  1. Log in to SQL Server Management Studio.

  2. Click Security, then click Logins.

  3. Right-click in the blank space, then select New Login.

  4. Enter a login name, then select SQL Server authentication.

  5. Enter a password, then, if required, select Enforce password policy.

  6. We recommend you clear the Enforce password policy check box.

  7. We recommend you clear the User must change password check box.

  8. Click the Server Roles tab, then select the required permissions.

  9. Click OK.

All permissions

Granting sysadmin at the SQL instance level will give the user permissions to all functions within the SelectPay Administrator.

Limited permissions

Alternatively, the user will need db_owner on each database required, and one or both of the following server roles:

  • dbcreator

  • processadmin

These roles will grant the following for the databases where the permissions have been granted;

  • Upgrade databases.

  • Back up databases.

  • Remove and apply unlocks to databases.

  • Delete databases.

  • View and manage users.

  • Syncing users from the user management database.

  • Creating new databases.

  • Actioning database restores.

  • Duplicating databases.

Related Articles
Did this answer your question?