Kbase P127204: How to audit specific fields of a table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/01/2009 |
|
Status: Verified
GOAL:
How to audit specific fields of a table?
FACT(s) (Environment):
OpenEdge 10.1x
Windows
FIX:
This example uses the sports2000 database for demonstration purposes.
This example requires 10.1A or greater version of Progress.
1) start a proenv session
On Unix issue the command <path to DLC installation>/bin/proenv
On Windows open a command prompt session and issue the command
<path to DLC installation>\bin\proenv.bat
2) prodb sports2000 sports2000
3) create the following add.st
d "Audit_Data",64,8 .
d "Audit_Index",64,8 .
4) add the new areas to the database
prostrct add sports2000 add.st
5) enable auditing
proutil sports2000 -C enableauditing area "Audit_Data" indexarea "Audit_Index" deactivateidx
6) load the standard policies distributed by Progress
a) proserve sports2000 -S <port name or number>
b) prowin32 sports2000 -S <port name or number> -H <hostname>
c) choose the Audit Policy Maintenance from the Tools menu
d) under the File menu choose import
e) import the <DLC installation path>/auditing/policies.xml
7) create an additional policy
a) highlight the policy tab
b) click the + option on the button bar
c) define the name for the new policy
d) click the save button on the button bar (little diskette icon)
8) define the table for which fields will be audited
a) select the Audit Tables tab
b) click on the + option on the button bar
c) type the table name or click on the binocular icon to select the table
d) leave everything defined as "Do not audit the table"
e) click the save button on the button bar (little diskette icon)
9) define the fields to be audited
a) click on the Audit Fields tab
b) click on the + option on the button bar
c) type the field name or click on the binocular icon to select the field