SQL Server Connection Required Permissions for the CDC Service
Important
Change Data Capture for Oracle by Attunity is deprecated now. For details, refer to the announcement.
The CDC Service Configuration Console requires connection information to SQL Server 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 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 |
|---|---|
| Prepare SQL Server 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 |
See Also
Connection to SQL Server
Connection to SQL Server for Delete
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for