Primary key columns

Primary key columns are handled differently from other columns. If an entry specifies C (log when changed) for a primary key column then the column is always logged, even if the column’s value is unchanged.

Example

dbtst120:*:A:bonus
dbtst120:*:C:salary
dbtst100:000:A
dbtst100:*:C

These statements hold for this example:

  • dbtst120.salary is audited only if the column itself has changed.
  • dbtst120.bonus is audited only if dbtst120.salary or dbtst120.bonus has changed.
  • No other column, including primary key columns, of dbtst120 is audited.
  • All columns of dbtst100 in company 000 are audited if any column of dbtst100 has changed.
  • Only the changed columns and the primary keys columns of dbtst100 in company 100 are audited if any column has changed.