Granting SQL user rights to start a SSIS Job
By default, only sa/admin users can start SSIS jobs, whether manually or by a schedule. To allow a normal SQL user to start a job, do the following:
Map the login user to the MSDB database and make sure the following roles are checked:
> db_ddladmin
> db_dtsadmin
> all SQLAgent roles.
You may also need to allow the following so your user can better see which jobs are not running and start them:
grant select on sysjobactivity to doclocator
grant select on sysjobs to doclocator
grant execute on sp_start_job to doclocator
Created By: amos 8/31/2010 11:20:13 AM
Updated: 8/31/2010 11:24:16 AM
|
|