SQL Server Connection Required Permissions for the CDC Designer

The CDC Designer Console requires connection information to SQL Server to perform its tasks. This topic describes the information that can be provided in the Connect to SQL Server dialog box for setting up the connection to SQL Server.

The Connect to SQL Server dialog box opens when necessary, such as when the SQL Server connection information is not available or when the information exists but the connection does not have the required permissions.

The following table describes the various tasks where a connection to SQL Server is required and the required permissions from the SQL Server login/user.

Task Minimum Permissions
View the list of CDC Services and Instances using the associated SQL Server instance. db_datareader role on MSXDBCDC
Start/Stop CDC Instance(s) db_datareader and db_datawriter roles on MSXDBCDC
View the CDC Instance status. db_owner role on the CDC Instance database
Create a new Oracle CDC Instance database. dbcreator fixed-server role
Create a new Oracle CDC Instance. db_datareader role on MSXDBCDC

db_owner role on the CDC database that was created.
Get deployment scripts. db_datareader and db_datawriter roles on MSXDBCDC

db_owner role on the relatedCDC database
Change configuration and add/remove capture instances. db_datareader and db_datawriter roles on MSXDBCDC

db_owner role on the related CDC database

See Also

Access the CDC Designer Console
SQL Server Connection for Instance Creation