Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

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: 31 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
17:03, 29 Sep 2016

Tags

Classifications

Public