How to Add a User to Pearl Email

Introduction:

This guide outlines the process for adding a new user to the Pearl Email system using SQL Server Management Studio (SSMS). Following this procedure ensures that new users are properly entered into the Pearl Master database and granted the appropriate access. Consistency in these steps helps maintain system security and data integrity.

Process description:

This process involves accessing the Pearl Master database within SSMS and editing the user table to add a new user with all necessary credentials and access permissions. It is essential for onboarding new employees or granting Pearl Email access to existing personnel.

Prerequisites:

• SQL Server Management Studio (SSMS) must be installed on your workstation.

• You must have appropriate permissions to connect to the database and edit tables within Pearl Master.

   

Gathering materials/resources:

• User’s full email address

• Domain information (e.g., Costco.com or cprs-inc.com)

• User’s account name

   

Step-by-step instructions:

1. Open SQL Server Management Studio (SSMS).

2. In the Connect to Server window, enter the following:

   • Server type: Database Engine

   • Server name: WTPWSQLEMLPROD1

   • Authentication: Windows Authentication

3. Click Connect.

4. In the Object Explorer, expand the Databases folder.

5. Expand Pearl Master.

6. Expand the Tables folder.t User and

7. Right-click on dbo.User and select Edit Top 200 Rows.

8. Scroll to the bottom of the table to the line that says NULL.

9. Fill in the following fields:

   • User Name: Enter the user’s email (e.g., Janedoe@Costco.com or CPRS-inc.com)

   • UserPrincipalName: Enter the same email address

   • Domain Name: Enter the appropriate domain (e.g., Costco.com or CPRS-inc.com)

   • Account Name: Enter the user's account name

   • ACTIVE: Enter TRUE to enable the account

   • Last Customer ID: Enter the required access level (usually 4)

   • Modified User ID: Enter the next available sequential number

10. Scroll to the far-left column, right-click, and choose Execute SQL to save and apply the changes.

     

Tips and best practices:

• Always double-check the email address and domain name for typos.

• Keep a running log of the Modified User ID numbers to avoid duplication.

• If unsure about the Customer ID level required, confirm with your team lead or supervisor.

   

Next steps:

• Inform the new user that their account has been created.

   

Disclaimer:

This guide is intended for authorized IT personnel with the proper permissions to access and modify the Pearl Master database. Follow all organizational policies and protocols.