With the Audit Trail feature, you can track and report changes made to Smart Materials users. The changes that are tracked are listed below.
-
User creation
-
Changes in user security for product groups or projects
-
Changes in user privileges.
-
User activation/deactivation
You can activate or deactivate the user auditing feature using the DBA setting AUDIT_ENABLE. Possible values of this DBA setting are:
-
Y - Audit is enabled
-
N (this is the default) - Audit is disabled.
When audit is activated, various events are captured and stored in the audit trail table. Captured information can be viewed on the A.60.86 Audit Trail screen. Currently, only user and user security changes are tracked. You can find details about the steps that were performed in the produced trace file. Trace files related to audit management are named with the prefix AUDIT_.
The DBA setting AUDIT_KEEP_TRAIL_DAYS allows you to specify how many days the audit trails will be available. The default value 0 means forever. With this parameter, you control when audit records are to be deleted by the DBMS job AUDIT_PURG.
The A.60.86 Audit Trail screen allows you to monitor tracked changes.
The Object Name field shows the type of change like ‘Users’, ‘User Securities’, and ‘User Privileges’. The type of change is shown in the Type field: ‘Insert’, ‘Update’, or ‘Delete’. The Performed By field shows the user who made the change. The user who was modified is stored in the Object Key field, and the modification date is shown in the Date of Change field. User security information is displayed in the Product Group, Project, Discipline, Role, and List View fields and by the Active indicator. The details of the modification are shown in the Description field.
The displayed records can be sorted by Object Name, Performed By, Object Key, and/or Date of Change, using the Sort Options at the bottom of the screen.
When audit is enabled, the following changes on A.20.05 will be tracked (Object name ‘Users’ on A.60.86).
-
First Name
-
Last Name
-
Telephone
-
Fax
-
Company
-
Department
-
Managed by
-
Email
-
Complex PW
-
User who performed this action
-
Action timestamp
On A.20.06.01 User Security for Product Groups, changes (insert/update/delete) in the following fields are tracked when audit is enabled (Object name ‘User Securities’ on A.60.86).
-
User
-
Product group
-
Discipline
-
Active
-
Role
-
View name
-
User who performed this action
-
Action timestamp
On A.20.06.02 User Security for Projects, changes (insert/update/delete) in the following fields are tracked when audit is enabled (Object name ‘User Securities’ on A.60.86).
-
User
-
Project
-
Discipline
-
Active
-
Role
-
View name
-
User who performed this action
-
Action timestamp
On A.20.06.04 User Privileges, changes (insert/update/delete) in the following fields are tracked when audit is enabled (Object name ‘User Privileges’ on A.60.86).
-
User
-
Project or product group
-
Discipline
-
Privilege
-
User who performed this action
-
Action timestamp
On A.20.06.21 Request for Rights, changes in the following fields are tracked when audit is enabled (Object name ‘User Privileges’ or ‘User Securities’ on A.60.86).
-
User
-
Product group or project
-
Discipline
-
Role
-
Privilege
-
View name
-
User who performed this action
-
Action timestamp
User creation is tracked on the A.60.01.01 Create User screen when audit is enabled, with the following information (Object name ‘Users’ on A.60.86).
-
User
-
First name
-
Last name
-
Company
-
Department
-
Fax
-
E-mail
-
Complex PW
-
Managed by
-
Telephone
-
User who performed this action
-
Action timestamp
User deletion is tracked on the A.60.01.02 Delete User screen when audit is enabled, with the following information (Object name ‘Users’).
-
User
-
First name
-
Last name
-
Company
-
Department
-
User privileges
-
User security for product groups, projects
-
User who performed this action
-
Action timestamp
Password changes on A.60.01.03 Change Password are tracked when audit is enabled, with the following information (Object name ‘Users’).
-
User
-
User who performed this action
-
Action timestamp
Privilege assignments done on A.60.63 Valid Settings are tracked when audit is enabled, with the following information (Object name ‘User Privileges’).
-
User
-
Project or product group
-
Discipline
-
Privilege name and status: active or deactivated
-
Action timestamp
You can use the DBMS job AUDIT_PURG on the A.60.45 DBMS Jobs screen to delete audit records depending on the value of DBA setting AUDIT_KEEP_TRAIL_DAYS.
