Required permissions
The Search 360 index is created in the same SQL Server instance as the iBase database. The indexing tools can either be run directly, or using the command line tooling, elsewhere on the network.
To use the indexing tools, you require a Microsoft SQL Server login with suitable administrative rights to allow databases and jobs to be created:
Task | Role |
|---|---|
To configure the index service | dbcreator server role |
To schedule an index service job on the database itself | SELECT, INSERT, UPDATE on _Configuration_Text; SELECT, INSERT, UPDATE on _Configuration_Def |
To schedule an index service job on the msdb database | Member of the SQLAgentUser role; SELECT on sysjobs |
After the index service is configured, you require an account to run the index service. In SQL Server, this can be one of the following:
a Windows account that is a member of the sysadmin server role
a proxy account that is a member of the "public database role" of the database to be indexed