What is the correct process for applying non-DBO access permissions? (20627)

An important thing to consider when installing InTrust is security for the databases that it is going to use. The accounts used by InTrust to access these databases can have the dbo role for the databases, or minimal privileges provided by special scripts.

If you use an account that has the dbo role, no database pre-configuration is needed. You can create databases as you proceed with the setup. In case you want to access the databases using the accounts without the dbo role, ask your database administrator to do the following before the actual installation:

1. Create the following databases to be used:
configuration, audit, and alert databases.

2. Run the configdb.sql and InTrust9_0_configuration_schema.sql scripts on the InTrust_Cfg_DB database created for InTrust configuration.

3. Run the auditdb.sql and ITFE80_EventsData.sql scripts on the InTrust_Audit_DB database created for audit data.

4. Run the alertdb.sql and InTrust9_0_alerts_schema.sql scripts on the InTrust_Alerts_DB database created for alerts.

If you are working with SQL Server 2005, consider assigning an appropriate Default Schema when assigning a role to SQL account.

Once you have completed these steps, your databases and accounts are ready to be specified during the installation. They will have the privileges required for proper InTrust operation without the dbo role.