Required permissions

The user specified in the endpoint settings must have the following privileges on the source database:

Running with the db_owner role

If the user is a member of the db_owner database role, the following permissions must be granted:

• On the master database:

  • grant VIEW ANY DEFINITION
  • grant VIEW SERVER STATE

• On the MSDB database:

  • grant SELECT ON SYSJOBACTIVITY

  • grant SELECT ON SYSJOBS

Running without the db_owner role

If the user is not a member of the db_owner database role, the following permissions must be granted:

On the master database:

• grant VIEW DATABASE STATE

On the source database:

• grant VIEW DATABASE STATE
• grant SELECT

On the MSDB database:

• grant SELECT ON DBO.CDC_JOBS
• grant SELECT ON DBO.SYSJOBACTIVITY
• grant SELECT ON DBO.SYSJOBS