| title | SQL Server Connection Required Permissions for the CDC Service |
|---|---|
| description | SQL Server Connection Required Permissions for the CDC Service |
| author | chugugrace |
| ms.author | chugu |
| ms.reviewer | mikeray |
| ms.date | 02/24/2026 |
| ms.service | sql |
| ms.subservice | integration-services |
| ms.topic | concept-article |
[!INCLUDE oracle-cdc-retirement]
The CDC Service Configuration Console requires connection information to [!INCLUDE ssNoVersion] to perform their tasks. This topic describes the information that can be provided in the Connect to SQL Server dialog box for setting up the connection to [!INCLUDE ssNoVersion].
The Connect to SQL Server dialog box opens when necessary, such as when the [!INCLUDE ssNoVersion] connection information isn't available or when the information exists but the connection doesn't have the required permissions.
The following table describes the various tasks where a connection to [!INCLUDE ssNoVersion] is required and the required permissions from the [!INCLUDE ssNoVersion] login/user.
| Task | Minimum Permissions |
|---|---|
| Prepare [!INCLUDE ssNoVersion] Instance. | dbcreator fixed-server role |
| Create an Oracle CDC Service-SQL Server login for use by the Oracle CDC service. | public fixed-server role |
| Create an Oracle CDC Service-login to use for registering the new service in MSXDBCDC. | db_datareader and db_datawriter roles on MSXDBCDC |
| Edit an Oracle CDC Service-login to use for updating the registration of the service in MSXDBCDC. | db_datareader and db_datawriter roles on MSXDBCDC |
| Delete an Oracle CDC Service-login to use for updating the registration of the service in MSXDBCDC. | db_datareader and db_datawriter roles on MSXDBCDC |