SQLTeam.com | Weblogs | Forums

CDC through SSIS Permissions Help


#1

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