| title | SQL Server Connection Required Permissions for the CDC Designer |
|---|---|
| description | SQL Server Connection Required Permissions for the CDC Designer |
| author | chugugrace |
| ms.author | chugu |
| ms.date | 03/14/2017 |
| ms.service | sql |
| ms.subservice | integration-services |
| ms.topic | concept-article |
[!INCLUDE oracle-cdc-retirement]
The CDC Designer Console requires connection information to [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion].
The Connect to SQL Server dialog box opens when necessary, such as when the [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] is required and the required permissions from the [!INCLUDEssNoVersion] login/user.
| Task | Minimum Permissions |
|---|---|
| View the list of CDC Services and Instances using the associated [!INCLUDEssNoVersion] 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 MSXDBCDCdb_owner role on the CDC database that was created. |
| Get deployment scripts. | db_datareader and db_datawriter roles on MSXDBCDCdb_owner role on the relatedCDC database |
| Change configuration and add/remove capture instances. | db_datareader and db_datawriter roles on MSXDBCDCdb_owner role on the related CDC database |
Access the CDC Designer Console
SQL Server Connection for Instance Creation