Please enter search query.
Search <book_title>...
Enterprise Vault™ Using SQL Database Roles in Enterprise Vault, Compliance Accelerator, and Discovery Accelerator
Last Published:
2021-03-23
Product(s):
Enterprise Vault (14.1, 14.0, 12.5, 12.4, 12.3, 12.2, 12.1, 12.0)
- About this guide
- Using Enterprise Vault database roles
- Configuring the Vault Service account for normal operations
- Using Compliance Accelerator and Discovery Accelerator roles
- Configuring the Vault Service account for normal operations
Creating EVScheduledSearchOperator in the msdb system database and assigning the Vault Service account
Use this procedure to do the following:
Create the EVScheduledSearchOperator role in the msdb system database. This role is required to support scheduled searches.
Assign the Vault Service account to the EVScheduledSearchOperator role.
To create the EVScheduledSearchOperator role and assign the Vault Service account
- Connect to the SQL server using SQL Server Management Studio.
- Click New Query and then enter the following query in the query editor window:
USE [MSDB] GO if not exists (select * from dbo.sysusers where name = N'EVScheduledSearchOperator') BEGIN CREATE ROLE EVScheduledSearchOperator Authorization dbo END GO GRANT SELECT ON sysjobs TO EVScheduledSearchOperator GRANT SELECT ON sysjobschedules TO EVScheduledSearchOperator GRANT SELECT ON sysjobsteps TO EVScheduledSearchOperator GRANT SELECT ON sysschedules TO EVScheduledSearchOperator GRANT EXECUTE ON sp_add_category TO EVScheduledSearchOperator exec sp_addrolemember SQLAgentUserRole, EVScheduledSearchOperator exec sp_addrolemember [EVScheduledSearchOperator], N'domain\vsa' GO
where domain\vsa is the Vault Service account and the domain to which it belongs.
- From the Query menu, click Execute, and then wait for the script to complete.