Using the Database option

If you make changes in the database table, they are reflected when a plan is opened. But if you delete a user from the database table, that user still appears in the plan object. You must change the Responsibility property for the Plan object for a new user. If you use the database table option and the table does not exist, the list of users is empty and an error is written in the log file.

You must do steps 2 through 5 for each plan.

To use the Database option:

  1. Start SQL Server Management Studio.
  2. Go to the Tables folder under the appropriate database folder.
  3. Open the ResponsibilityUsers table and view all rows.
  4. Click in the last row.
  5. Fill in the Name field for each user (no more than 50 characters). If required, you can also fill in the FullName (maximum of 100 characters) and Description (maximum of 255 characters) fields for each user as well.
    Option Description
    Name This is the short user name. It is required and can be a maximum of 50 characters.
    FullName This is the full user name. It is optional and can be a maximum of 100 characters.
    Description This is optional and can have up to 255 characters.
  6. Close SQL Server Management Studio.
  7. Open the Set Properties page.
  8. Go to the userDirectoryPath line.
  9. In the Value column, specify:
    Database://DisplayField=FullName