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