SQLTeam.com | Weblogs | Forums

CDC through SSIS Permissions Help

Hi All,

We are planning to implement some packages using the CDC Tasks and am having trouble understanding the required permissions. Aside from granting DB_Owner, what permissions would I need to grant to be able to run these?

I've searched online and this is the only related article I've found

Becau_se the db_owner is a powerful role, when defining capture instances within SQL Server 2016 it is recommended to associate a gating security role to each capture instance that allows the SSIS CDC package to use a much more restricted user for processing the changes.'

Thanks All