Grant Guidewire Data Management view permissions to pcUser

About this task

PolicyCenter supports several different data management pages for performance analysis of the application. To use these pages, you must grant the pcUser the following permissions on each PolicyCenter data management view:

  • view server state
  • view database state

The data management views all start with a sys.dm_ prefix.

Procedure

  1. If not already open, open SQL Server Management Studio.
  2. In Object Explorer, right-click the database and select Properties.
  3. Select the Permissions page.
  4. Select pcUser.
  5. Select the check box to grant view database state permission.
  6. Click OK.
  7. Right-click the server and select Properties.
  8. Select the Permissions page.
  9. Select the login associated with pcUser.
  10. Select the check box to grant view server state permission.
  11. Select the check box to grant create any database permission.
    This permission allows the gwb dropDb command to recreate the database.
  12. Click OK.