Friday, May 23, 2008

Enabling or Disabling Auditing resulting in some loss of data?

If you observe, Enabling/Disabling 21 CFR11 Auditing a table resulting in some loss of data,make sure the user with which you are enabling/disabling doesn't have any row security.
Suppose you are disabling auditing on F0101, and you have row security restriction that you cannot see the data from AN8=20 to AN8=50.When you disable auditing, the records in this range are not selected for insertion[from F0101_ADT to F0101].
Tip: So never enable/disable auditing with a user having row security restrictions
Note: All CFR configuration changes are recorded in to the Security History table,F9312

No comments: