How To - Set Database Permissions for Integrator
This topic describes the permissions that must be granted for an SQL user-account that will be used with Event 1 Integrator.
1. First connection to a Prolog Database.
The first time that a connection is established with a Prolog Manager database, the SQL Server user account must either be "sa" or an account that is a member of the "System Administrators" Server Role. After the Prolog Manager database has been accessed by Integrator for the first time, the account used subsequently does not need to be a member of "System Administrators" so long as it has the appropriate permissions as discussed below. The reason that a "System Administrator" account is needed the first time is to allow Integrator to establish the Login and User Account for the AI-SDK.
Note that the SQL Server Login that you use with Integrator must have access to the Integrator database and any Prolog Manager databases to be used with Integrator.
How To - Add or Remove Logins in the System Administrator Role
2. Prolog Manager Permissions
If the SQL Server user account being used to access a Prolog Database is not a member of the "System Administrators" Server Role and is not assigned the db_owner Database Role, the following Database Roles must be granted for the account:
- public
- db_datareader
- db_datawriter
How To - Add or Remove Database Roles
3. Integrator Database Permissions
If the SQL Server user account being used to access the Integrator database is not a member of the "System Administrators" Server Role and is not assigned the db_owner Database Role, the following Database Roles must be granted for the account:
- public
- db_ddladmin
- db_datareader
- db_datawriter
How To - Add or Remove Database Roles
How To - Add or Remove Logins in the System Administrator Role
- Start SQL Enterprise Manager
- In the tree on the left, locate your SQL Server and expand the tree below it.
- Expand the Security branch and then click on the Login node
- Right-click on the Login ID in the list and select Properties
- On the Server Roles tab, check or uncheck the System Administrators box
How To - Add or Remove Database Roles
- Start SQL Enterprise Manager
- In the tree on the left, locate your SQL Server and expand the tree below it.
- Expand the Databases branch and then expand the branch for the database.
- Click on the Users node.
- Right-click on the Database User and select Properties
- In the list of Database Roles, check or uncheck the roles as needed.