Database audit control keeps an audit log of amendments, additions or deletions of database columns and their values. Only one user at a time can use this function.
Note: There is no delete option in Audit control. If you need to remove an audit control record you have to amend the required record and remove all of the columns.
The Database audit form is displayed when you click System Utilities > MANAGEMENT MENU > Database audit menu > Audit Control.
Filters:
Module: Click the
search button to select the required module.
Company: Click the
Table: Click the
Available columns to add from dictionary: Once a Module, Company and Table have been selected the corresponding columns and there descriptions will be displayed in a grid form
Column list to be audited: Once the relevant columns have been selected the will be displayed within this grid.
Tip: Items in [brackets] have database audit control records on file.
Buttons:
Add: There are two buttons here a single and double forward arrow, the single forward arrow is used to add individual columns and the double for adding all columns into the Column list to be added grid.
Remove: These to buttons work in the same way as the Add buttons but will remove single or all columns from the column list to be added grid back to the Available columns to add from the dictionary grid.
Clear: Will clear all of the selected criteria in the filters.
Reports Click to display view current database audit controls.
Create/Edit: Click to create a new record, this will change to amend if a record already exists.
Save: Save new or amended records.
Cancel: Will only be enabled when in amend or create mode.
Help: Displays help on the current application in your default company browser.
Exit: Returns to the SU Management Menu.
This option is displayed by clicking the Reports button on the Database audit control form. It searches for all or selected tables/columns that have an audit control.
Filters:
Module: Click the
Company: Click the
Table: Click the
Display Grid: Displays the results of the search as below.
Module
Company
Table
Column
Note: Only records that have an audit control will show within this search e.g. if no audit controls have been used in SR, SR will not show in the Module drop down. Likewise for the Company and Table drop downs.
Buttons:
Refresh: Searches for criteria in the Module, Company or Table.
Reset: Resets all the data back to default.
Exit: Returns to the Database audit control form.
