Kbase P133643: Are RECID or ROWID used to identify recorded Audit Data?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/25/2008 |
|
Status: Unverified
GOAL:
Are RECID or ROWID used to identify recorded Audit Data?
GOAL:
How do I identify what application record an audit record was recorded for?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1x
FIX:
RECIDs and ROWIDs are considered temporary phenomena that are specific to an instance of a database. These values are recycled and re-used in different tables and databases and are therefore not considered reliable for identifying Audit Data that was recorded.
When an audit data record is created for a Create, Update or Delete event stores information to identify the record being audited in the _event-context field as a CHR(7) CHR(6) delimited list of values. If no custom identifying fields were specified in the audit policy for the table/event that caused the data to be recorded then the values from the primary index are stored in the _event-context field.