DBohner-(db)
Legendary Poster
Howdy,
I'm at a client that currently has CFR 21 Part 11 turned on for several tables. I've been asked to turn on auditing for a couple more table/columns....
I've been through the guide, several times, and my overly cautious mind keeps missing to grasp a step or two.
Paraphrased from the CFR 21 Admin Guide:
3.3.2
Fast Path P9500003
1 'Work with Audit Table', Click Add
2 On Audit Table Setup Director, "Next"
3 On Table Selection Form, Select Table, then "Next"
4 On Audit Table Information Form, make changes if necessary, then "Next" (this opens TDA in Audit Mode)
5 In TDA (Audit Mode), move the columns you want audited to the Columns Pane
6 In TDA (Audit Mode), you can right click columns in the Columns pane and turn on/off the 'Trigger'
7 Click Save, then Close in TDA (Audit Mode)
8 On the Work with Audit Table Configurations form, click "End"
9 Restart all Servers / Clients
?? Do we really need to restart, yet?
Note: The Audit Table is created in your Default Project.
*** Check-In the Audit Table
P9500003, Select Table, "Check In" row exit
*** Enable Auditing for Table (only for an environment that already has Auditing 'Enabled')
10 P9500003, Select Table
11 Row Exit, "Select Enable DB Auditing"
12 Restart all servers and clients
So, the questions:
A - Do we have to bounce All Servers / Clients (All Environments associated with 'System')? Or, is bouncing an environment sufficient?
B - What 'Generates' the Audit (A*) table? Does enabling it generate it or does the Developer / CNC have to Generate it via TDA?
C - Are Native Database Triggers being used (the documentation says 'yes', but it's not validated by the user community).
D - If the users decide to audit more columns on an already audited table, will the 'history' be wiped out during the revision process?
E - Do we Promote the Audit Table through environments?
What else have I forgotten?
(db)
I'm at a client that currently has CFR 21 Part 11 turned on for several tables. I've been asked to turn on auditing for a couple more table/columns....
I've been through the guide, several times, and my overly cautious mind keeps missing to grasp a step or two.
Paraphrased from the CFR 21 Admin Guide:
3.3.2
Fast Path P9500003
1 'Work with Audit Table', Click Add
2 On Audit Table Setup Director, "Next"
3 On Table Selection Form, Select Table, then "Next"
4 On Audit Table Information Form, make changes if necessary, then "Next" (this opens TDA in Audit Mode)
5 In TDA (Audit Mode), move the columns you want audited to the Columns Pane
6 In TDA (Audit Mode), you can right click columns in the Columns pane and turn on/off the 'Trigger'
7 Click Save, then Close in TDA (Audit Mode)
8 On the Work with Audit Table Configurations form, click "End"
9 Restart all Servers / Clients
?? Do we really need to restart, yet?
Note: The Audit Table is created in your Default Project.
*** Check-In the Audit Table
P9500003, Select Table, "Check In" row exit
*** Enable Auditing for Table (only for an environment that already has Auditing 'Enabled')
10 P9500003, Select Table
11 Row Exit, "Select Enable DB Auditing"
12 Restart all servers and clients
So, the questions:
A - Do we have to bounce All Servers / Clients (All Environments associated with 'System')? Or, is bouncing an environment sufficient?
B - What 'Generates' the Audit (A*) table? Does enabling it generate it or does the Developer / CNC have to Generate it via TDA?
C - Are Native Database Triggers being used (the documentation says 'yes', but it's not validated by the user community).
D - If the users decide to audit more columns on an already audited table, will the 'history' be wiped out during the revision process?
E - Do we Promote the Audit Table through environments?
What else have I forgotten?
(db)