Configuring CDC user identity using OpenEdge Management

Change Data Capture allows you to record the identity of the user who made changes to the database's user tables. This identity is recorded based on the database connection or the application session used by that user. However, you can also choose not to record any user identity.

Using the Database Security Options page in OpenEdge Management, you can configure how you want to record a user's identity in the change tracking table.

Note: Ensure that Change Data Capture is enabled before configuring this option.

To configure a user's identity for CDC:

  1. From the OpenEdge Management menu, click Database Administration > Go to Database Administration.
    The Database Administration page appears.
  2. Filter or search for, and select the required database connection.
    The database connection home page appears.
  3. In the Security Summary section, click Edit security options. This link is enabled only when a user is logged into the database with administrator privileges.
    The Database Security Options page appears.
  4. Under Change Data Capture user identity section, select one of the following options:
    • None — Does not record any user identity.
    • Database — Records the user's identity based on the database connection used by the user.
    • Application — Records the user's identity based on the application session used by the user.
  5. Click Commit to save your settings.