Configure the SQL database CIC accounts

The CIC database has three default accounts with different permission levels to provide different levels of access to the database. IC Setup Assistant creates the tables and grants permissions to these standard database user accounts in a new database and verifies this information for existing databases.

Enter the names and passwords for the following CIC accounts.

Note: You must enter a password. IC Setup Assistant does not allow blank passwords for database user accounts.

The database administrator may have a password policy (for example, at least six characters long, must start with a number, etc.). Be sure to remember or record in a safe place the passwords you enter here.

Administrator Account

IC_Admin is the administrative account with the db_owner role and owns all the tables on the database server with "dbo" schema. It can be used to perform administrative tasks on the database (performance tuning, backups, etc). IC_Admin is used by the IC Tracker and IC Report Logging Data Sources defined in Interaction Administrator.

User Account

IC_User is the user account used by CIC Server components to read and write to the database.

Read-Only Account

IC_ReadOnly is the read-only account used by the CIC Server and client components to query the database.