follow the below process to grant access for Integration services:
GO: MSDB --> Security --> Roles --> db_ssisltduser --> add the user/group name
Give SQLAgentOperatorRole --> if they want them to schedule it.
For more on integration securities please refer the link:
http://msdn.microsoft.com/en-us/library/ms141053.aspx
Thanks,
Satish Kumar.
No comments:
Post a Comment