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.
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