The Data Masker software requires an audit table to be present in the target database. The audit table is always named DMS_AUDITTAB and is used to record the rules as they execute. The audit table makes it possible to determine which masking rules have been executed in the database and also makes it possible to restart the rules if an error occurs.

The audit table can be emptied at the start of each masking set run by choosing the Truncate audit table before each run option on the Misc. Setup Tab.

The structure of the Audit Table

The Audit table has the structure shown below.

--
-- copyright (c) 2008 - Net 2000 Ltd. All rights reserved
--                  www.DataMasker.com
--
-- The Data Masker audit table records the successful completion
--   of the masking rules. This makes restarts and auditing
--   possible.
-- 

drop table [DMS_AUDITTAB];
CREATE table [DMS_AUDITTAB]
(
   completion DateTime,
   runid varchar(100),
   ruleblock int,
   ruleid int,
   ruletype varchar(50),
   target varchar(100),
   runtime decimal,
   checkval int,
   status char
);

completion

The Sql Server timestamp indicating the date and time of the rule completion.

runid

Multiple runs of same masking set (or different masking sets) can be recorded in the audit table. This field indicates the set name and the start time of the masking set and allows the records for individual runs to be selected.

ruleblock

The ruleblock of the rule recorded in that audit table row.

ruleid

The ruleid of the rule recorded in that audit table row.

ruletype

A summary of the rule type of the rule recorded in that audit table row.

target

The target table or object of the rule recorded in that audit table row.

runtime

The execution time in seconds of the rule recorded in that audit table row.

checkval

A checksum for the rule. This permits the audit table entries to be checked against a known list to see if previously tested and validated rules have been updated or modified. For rule types of New Run Marker, which indicate the start of a masking set run, the checksum value is the checksum of the collection of rules and also the Data Masker options configuration.

status

The status of the rule. Will always be a C if the rule successfully completed.

The Missing Audit Table Form