Database Security System User Guide

SOX Report Specifics End of Period Adjustments Report (EPA)
FortiDB Version 3.2 Utilities User Guide
15-32000-81369-20081219 49
Determining Your Reporting Period
Reporting Period is the time frame surrounding a user-defined period-end day
(PED). The reporting period extends a user-defined number of days before
(UDDB) and a user-defined number of days after (UDDA) the PED.
Assumptions:
PED = the 1st day of each month
UDDB = 8
UDDA = 15
Case 1
Assumption:
You are running your End of Period Adjustments (EPA) report sometime before
midnight on the first day of August
Assertions:
a) the most recent PED is the first day of July
b) the reporting period is (July 1)- 8 days until (July 1) + 15 days
Conclusion:
The resulting report period is June 23 until July 16, inclusive.
Case 2
Assumption:
You are running your End of Period Adjustments (EPA) report sometime before
midnight on the second day of August
Assertions:
a) the most recent PED is the first day of August
b) the reporting period is (Aug 1)- 8 days until (Aug 1) + 15 days
Conclusion:
Object The name and owner of the database object that was directly manipulated by
the flagged activity
Time Stamp The exact time the flagged activity was conducted.
Terminal Name The terminal IP address or name.
Origin Application The name, or other identifier, for the originating application, if the activity
originated from an external application or from an application server.
Action The type of action successfully completed by the User ID.
Column
Description