Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange CDC Introduction
  3. Part 2: PowerExchange CDC Components
  4. Part 3: PowerExchange CDC Data Sources
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

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

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 have System Administrator authority, or the SA role.
  • To create registration groups and capture registrations from the PowerExchange Navigator, you must have DB_OWNER authority.
    The first time you add a registration group in the PowerExchange Navigator, PowerExchange creates a publication named "PowerExchange Change Capture." If you did not previously enable transactional replication on the publication database, PowerExchange also attempts to enable transactional replication. In this situation, you must have System Administrator authority, or the SA role, to enable transactional replication and create the first registration group. Thereafter, users with DB_OWNER authority can add registration groups under their own user IDs and passwords and add capture registrations.
  • To run change data extractions against a SQL Server distribution database, you must have read access to that database.
If you do not specify a user ID and password when creating a registration group, the PowerExchange Navigator and the extraction processes attempt to use your Windows user ID and password to connect to the SQL Server distribution database.

0 COMMENTS

We’d like to hear from you!