Managing SQL Server Environment Users

Prerequisites

Users that you add to an environment must meet the requirements for that environment as described in the platform-specific Requirements topics.

Procedure

1. Login to the Delphix Admin application using Delphix Admin credentials.
2. Click Manage.
3. Select Environments.
4. Click the name of an environment to open the environment information screen.
5. Under Basic Information, click the green Plus icon to add a user.

6. Enter the Username and Password for the OS user in that environment.

    

   Using Public Key Encryption

   If you want to use public key encryption for logging into your environment:

   1. Select Public Key for the Login Type.
   2. Click View Public Key.
   3. Copy the public key that is displayed, and append it to the end of your ~/.ssh/authorized_keys file. If this file does not exist, you will need to create it.
      
      1. Run chmod 600 authorized_keys to enable read and write privileges for your user.
      2. Run chmod 755 ~ to make your home directory writable only by your user.

   The public key needs to be added only once per user and per environment.

   You can also add public key authentication to an environment user's profile by using the command line interface, as explained in the topic CLI Cookbook: Setting Up SSH Key Authentication for UNIX Environment Users.

7. Click the Check icon to save the new user.
8. To change the primary user for this environment, click the Pencil icon next to Environment Users.
9. To delete a user, click the Trash icon next to their username.