OpenEdge Release 11.7.2 Service Pack includes the following improvement to OpenEdge Management:
Support for Change Data Capture user identity — OpenEdge Management now supports configuration of Change Data Capture user identity.
In release 11.7.2, 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.
To configure a user's identity for CDC, perform the following:
1. From the OpenEdge Management menu, click Database Administration > Go to Database Administration and select the required database connection.
2. In the Security Summary section of the database connection home page, click Edit security options. This link is enabled only when a user is logged into the database with administrator privileges.
3. In the Database Security Options page, 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.
You can also access these options by selecting Admin > Database Options in the Data Administration utility.
Updating database options schema
You can use the following code to manually update the _db-options schema for CDC user identity:
Support for Change Data Capture user identity — OpenEdge Management now supports configuration of Change Data Capture user identity.