Overview of database permissions used for Guidewire applications

PolicyCenter must be able to connect to your database through a user. Create a user called pcUser in your database. PolicyCenter connects to the user named pcUser. The pcUser must have the correct permissions. The following tables lists the permissions required for each database:

Database	Permissions Required
Oracle	The `pcUser` must have the following permissions on the PolicyCenter Oracle database: Alter session Create operator Create procedure Create sequence Create session Create table Create trigger Create view Query rewrite Select any dictionary Load Class (if using Amazon RDS and GWNormalize Java function to configure search rules.) If your users want to see statspack data on the Server Tools Info Pages > Oracle Statspack screen, grant the `pcUser` access to the PolicyCenter performance statistics (`perfstat`) tables.
SQL Server	The `pcUser` must have the `public` and `db_owner` roles on the PolicyCenter SQL Server database. PolicyCenter supports several different data management pages for performance analysis of the application. To use these pages, the `pcUser` must be granted `view server state` in PolicyCenter. The server login account must also have `view database state` permission on each PolicyCenter data management view. The data management views all start with a `sys.dm_` prefix.

Database

Permissions Required

Oracle

The pcUser must have the following permissions on the PolicyCenter Oracle database:

Alter session
Create operator
Create procedure
Create sequence
Create session
Create table
Create trigger
Create view
Query rewrite
Select any dictionary
Load Class (if using Amazon RDS and GWNormalize Java function to configure search rules.)

If your users want to see statspack data on the Server Tools Info Pages > Oracle Statspack screen, grant the pcUser access to the PolicyCenter performance statistics (perfstat) tables.

SQL Server

The pcUser must have the public and db_owner roles on the PolicyCenter SQL Server database.

PolicyCenter supports several different data management pages for performance analysis of the application. To use these pages, the pcUser must be granted view server state in PolicyCenter. The server login account must also have view database state permission on each PolicyCenter data management view. The data management views all start with a sys.dm_ prefix.