QAD 2017 Enterprise Edition
>
User Guides
>
Security Administration
>
Auditing
>
Set Up Auditing
Set Up Auditing
To set up auditing, you must load the license for Enhanced Controls and then do the tasks described in the following sections:
Note: When setting up auditing, QAD recommends that you first set up a test environment to test the auditing policy and then export the policy and load it into the production database.
Enable Auditing for the Database
In most cases, enable auditing on the database and archive database with these commands:
> yab -deactivateidx database-qaddb-auditing-enable
> yab database-qadarc-auditing-enable
For the generic case, all databases are preconfigured with database areas to store auditing data and indexes. To enable auditing on all databases, execute the command:
> yab database-auditing-enable
Alternatively, to enable auditing on a specific database, execute the command:
> yab database-[INSTANCE]-auditing-enable
Non-primary indexes are deactivated by default to improve performance when using database auditing. Deactivated indexes may be activated using PROUTIL IDXBUILD. The non-primary indexes are useful for reporting and can be activated on your audit archive database.
If you have activated non-primary indexes and want to deactivate them again, execute the command:
> yab -deactivateidx database-[INSTANCE]-auditing-enable
Note: The database must be offline to enable auditing.