Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Database Performance Analyzer (DPA) > Database Performance Analyzer Getting Started Guide > Set up user accounts > Add user accounts and assign privileges

Add user accounts and assign privileges

Created by Melanie Boyd, last modified by Melanie Boyd on Sep 29, 2016

Views: 177 Votes: 0 Revisions: 4
DPA_GS_Home.png

You must add a user account for each person who needs to log in to DPA. Each user is assigned a role, which determines the user's permissions.

Before you add users, determine who needs access to DPA and which privileges each user needs. For more information about the available options, see DPA roles and privileges.

Optionally, you can integrate DPA with your company's Active Directory (AD) or LDAP service. If you do this:

  • Users can log in to DPA with their domain accounts.
  • You can add AD or LDAP groups to DPA and assign privileges to each group.

Add a read-only user

The following example shows how to add a user with read-only privileges for all database instances.

  1. In the upper-right corner of the DPA window, click Options.
  2. Click the Administration tab, and select User Administration.
  3. On the User Administration page, click Create User.
  4. Enter a unique user name and a password.
  5. Select the Read Only on All Instances role.

    File:Success_Center/New_Articles/DPA_Getting_Started_Guide/050/020/gs_read_only_user.png

  6. Click Save.

Add a user with custom privileges

The following example shows how to add a user with custom privileges. This user has access to only one database instance.

  1. In the upper-right corner of the DPA window, click Options.
  2. Click the Administration tab, and select User Administration.
  3. On the User Administration page, click Create User.
  4. Enter a unique user name and a password.
  5. Select the Custom Privileges Specified Below role.

    File:Success_Center/New_Articles/DPA_Getting_Started_Guide/050/020/gs_custom_user.png

  6. To grant access to data from all database instances, select privileges in the top row. To limit access, select privileges for each database instance.

    The View Data privilege is automatically selected when you select any higher privilege.

    In the example below, the user can access data from only one database instance. This user can make changes to monitoring options, run reports, and view existing alerts for the selected instance.

    File:Success_Center/New_Articles/DPA_Getting_Started_Guide/050/020/gs_custom_user_privs.png

  7. Click Save.
Last modified

Tags

Classifications

Public