Assigning the permissions and roles required to create search schedules
|Article:HOWTO58555|||||Created: 2011-08-01|||||Updated: 2012-09-22|||||Article URL http://www.symantec.com/docs/HOWTO58555|
If you do not assign the SQL sysadmin role to the Vault Service account, you must grant sufficient permissions and roles to this account to make it the creator and owner of Compliance Accelerator search schedules. Briefly, you must do the following:
The following sections describe these activities in more detail.
On the SQL Server computer, start SQL Server Management Studio.
Select the required SQL Server.
Browse to Databases > System Databases > msdb > Security > Users.
Right-click Users, and then click New User.
In the User name box, enter a new user name.
In the Login name box, enter the domain and user name of the Vault Service account in the form domain\user_name.
Right-click the new user that you have just created, and then click Properties.
Select the Securables page.
Add the stored procedure sp_add_category to the list of securables, and then grant the Execute permission for it to the Vault Service account.
Browse to Databases > System Databases > msdb > Security > Roles > Database Roles.
Right-click SQLAgentUserRole, and then click Properties.
On the General page, click Add, and then select the Vault Service account that you have just created.
Article URL http://www.symantec.com/docs/HOWTO58555