SQL Server logins and Windows accounts

The SQL Server login, or Windows™ account, you use to run the Index Service Configuration tool requires the following permissions:


Action	Permission
When the index service configuration tool is started for the first time to create the IBaseIndexDB database.	`dbcreator` server role
To create the IBaseIndexDB database table.	`db_owner` database role on the `IBaseIndexDB` database
To detect the IBaseIndexDB database table.	`db_datareader` on the `IBaseIndexDB` database
To add new records into the table.	`db_datawriter` on the `IBaseIndexDB` database
To schedule an index service job.	`db_datareader` on the actual iBase database `SELECT, INSERT, UPDATE` on `_Configuration_Text` on the actual iBase database `SELECT, INSERT, UPDATE` on `_Configuration_Def` on the actual iBase database
To create a job.	`db_datawriter` on the `IBaseIndexDB` database `SELECT` on `sysjobs` within the `msdb` database `EXECUTE` on `sp_add_job` within the `msdb database` `EXECUTE` on `sp_add_jobstep` within the `msdb` database `EXECUTE` on `sp_add_jobschedule` within the `msdb` database `EXECUTE` on `sp_add_jobserver` within the `msdb` database
To delete a schedule.	`EXECUTE` on `sp_help_job` within the `msdb` database `EXECUTE` on `sp_help_jobstep` within the `msdb` database `EXECUTE` on `sp_help_jobschedule` within the `msdb` database `EXECUTE` on `sp_help_jobserver` within the `msdb` database `EXECUTE` on `sp_delete_job` within the `msdb` database