Only specific privileged users are authorized to utilize CDC. These include:

Installation Owner: The user account that initially installed the Ingres database system has full control and, by default, access to key system functions including CDC.

Database Owner: The user who created the database has full control over it and has access to CDC for that specific database.

DB_ADMIN Privileged Users: Users who are explicitly granted the DB_ADMIN privilege are considered as database administrators. This privilege provides a wide range of administrative capabilities, including access to CDC.

It is crucial to manage these privileges carefully to prevent unauthorized access to sensitive change data.

Journaling must be enabled at the database level for the CDC mechanism to function effectively.

To enable journaling for a specific database, execute the following command:

where <dbname> is the name of the Ingres database for which you want to enable journaling. This command initiates the journaling process, ensuring that all subsequent data modifications recorded in the transactional log file are copied to journal files. In addition to database-level journaling, individual tables targeted for change data capture must also have logging enabled.