CDC Guide for Linux, UNIX, and Windows

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Required User Authority for SQL Server CDC

Verify that you have the proper authority level to complete registration and SQL Server configuration tasks.

The following user authority levels are required:

To enable transactional replication on the publication database, you must be assigned the System Administrator role.

To create a PowerExchange publication that is associated with a distribution database, you must be assigned the System Administrator role.

In the PowerExchange Navigator, the first time you add a registration group for a distinct publication database, PowerExchange creates the publication named "PowerExchange Change Capture" and enables transactional replication on the publication database if replication is not yet enabled. The creation of the PowerExchange publication requires you to have the System Administrator role. Thereafter, when you create additional registrations for the same publication database, you need the DB_OWNER role.

To create capture registrations from the PowerExchange Navigator and allow PowerExchange to generate the corresponding SQL Server articles in the publication, you must be assigned the DB_OWNER role.

To run change data extractions against a SQL Server distribution database, you must have read access to the database. Also, you need SELECT authority on the MSrepl_commands and MSrepl_transactions system tables in the distribution database.

If you use Microsoft SQL Server NTLM and Active Directory authentication to control access to a SQL Server database, you can enter a user ID and password that has the proper authority when creating a registration group or performing a database row test. Enter the user ID in the format

domain\user_name

If you do not specify a user ID and password when creating a registration group, the PowerExchange Navigator and the extraction processes try to use your Windows user ID and password to connect to the SQL Server distribution database.

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Required User Authority for SQL Server CDC

Required User Authority for SQL Server CDC