[MSSQL] CDC Role
·
DataBase/MSSQL
Role Enalbe/Disable for Database We must enable database before enable CDC on individual table. Product Role SQL Server sysadmin Azure SQL Server db_owner Azure SQL Managed Instance sysadmin Enable/Disable for Table Only `db_owner` can enable or disable CDC for individual table Access to a change table CDC 활성화시 다음과 같은 구문을 사용하는데 @role_name 을 지정하도록 되어있다. -- ========= -- Enable a Table Without Usin..