3305 Main Street Ste 019 Vancouver, WA 98663

Buyout Database Security

Background

This topic addresses the security settings required in order for users to access the Buyout database. Note that two methods of configuring security are provided. The first (preferred option) is to use Buyout Database Manager (v2.0.37 or higher) to add or remove users. The second option requires the use of Microsoft SQL Server Management Studio (SSMS).

Controlling User Access via Buyout Database Manager

Note - This process requires Buyout version 2.0.37.

  1. Start Buyout Database Manager
  2. Select the Buyout database from the list of databases.
  3. Click Configure.
  4. On the left, click User Access.
  5. A list of users (and groups) that have already been granted access will be shown. Click the plus button (+) to add a new user or group.
  6. In the Group or User box, enter the fully qualified domain user name or domain group (e.g., MYDOMAIN\username) and click OK.
  7. Repeat the above step for each additional user or group that should be granted access.
  8. To remove users or groups, click the "X" button.
  9. .
  10. Click Save and then close Buyout Database Manager.

Controlling User Access via Microsoft SQL Management Studio

Note - You may need to install Microsoft SQL Server Management Studio if it is not already installed.

  1. Start Microsoft SQL Server Management Studio and connect to the SQL Server instance containing your Buyout database.
  2. Expand the Security node and then the Logins node.
  3. For each user or group, if you not see the user or group listed here, follow these steps -
    1. Right-click on the Logins node and click New Login.
    2. In the Login name box type the fully qualified domain user name or domain group (e.g. "MYDOMAIN\username").
    3. Click the Windows authentication radio button.
    4. Click OK.
  4. Expand the Databases node.
  5. Expand the node representing your Buyout database.
  6. Expand the Security node and then the Users node.
  7. For each user or group , if you do not see the user or group listed here, follow these steps -
    1. Right-click on the Users node and click New User.
    2. In the User type drop-down, select Windows user.
    3. In the User Name and Login Name boxes, type the fully qualified user or group name (e.g., "MYDOMAIN\username").
    4. In the Default Schema box, type dbo.
    5. On the left, click Membership and then check the following boxes -
      • db_datareader
      • db_datawriter
      • db_ddladmin
    6. Click OK
  8. Close Microsoft SQL Server Management Studio.