Fortinet FortiDB manual Verification of Audit Settings Report VAS, VAS Report Sample

Page 52

Verification of Audit Settings Report (VAS)

SOX Report Specifics

The resulting report period is July 24 until August 16, inclusive.

Note: Since the time frame from August 3rd and beyond is a future time frame, there will be no data for it in the report.

Verification of Audit Settings Report (VAS)

VAS Report Sample

COBIT Objectives and Setup Requirements

Objective		FortiDB MA Module Setup
Number(s)	Objective Description	Requirement

DS3.5, DS5.5,	Audit tracking is configured on all financial	There are two requirements:
DS13.3	databases, changes to audit functionality is	1. At least one of the following
	reviewed by IT Management on a quarterly	1. At least one of the following
	reviewed by IT Management on a quarterly	modules must be run in order to
	basis.	modules must be run in order to
	basis.	collect audit data:
		collect audit data:
		• UBM
		• PM: using the Audit data
		retrieval method
		• MM: using the Audit data
		retrieval method
		2. For tracking audit activity with the
		UBM module, run the following
		commands:
		audit system audit;
		audit audit system;
		audit audit any;
		and then Close and Open your
		database connection in UBM.

Report Body Columns

	The following columns are displayed in the report body:

Column	Description

User ID	The ID of the database user that conducted the flagged activity.

	FortiDB Version 3.2 Utilities User Guide
50	15-32000-81369-20081219

Image 52

Contents Utilities User Guide FortiDB Utilities User Guide TrademarksTable of Contents Index FortiDB MA Utilities Auto Discovery Selecting Addresses for Auto-DiscoverySelecting Non-Standard Ports for Auto-Discovery Results from Auto-DiscoveryMS-SQL Discovered Database Information Populating Connection FormMS-SQL Connection Summary Connection Summary Button Connection Summary OutputRule Chaining Setting Screen Rule ChainingRule Chaining Chaining with Parameterized User-Defined Rules Parameterized User-Defined Rule Flow Diagram General Pudr StepsDisabled Parameter Checkboxes Validating the Pudr before SavingItem Setting for Session Policy Example of Chaining to a PL/SQL-based PudrPolicy Settings for Suspicious Login Time Immediate Chained-Rule Alerts UBM Session Policy and Pudr Table Columns That Could Appear in AlertsResulting Killed Session Multiple Source-Rule-Violation Behavior DB ExampleRule Chaining Setting a Timer-based Schedule Setting a Report ScheduleAlert Report Manager Deleting a Previously Set Timer Schedule Setting a Calendar-based ScheduleSetting a Timer-Based Schedule Deleting a Timer ScheduleSetting a Combined Schedule Setting a Randomized IntervalSetting a Calendar-Based Schedule Setting a Randomized IntervalReporting by Time Enabling Email RecipientsSpecifying Report Parameters ARM Reporting by Time ARM Reporting by Time Calendar Pop-upNew Report Setting Screen top New Reports MenuNew Report Setting Screen bottom Saved and Enabled Report Using the Select Checkbox to Affect Multiple ReportsActivating ARM Running and Analyzing ReportsStatus Menu Status Dialog View Reports Dropdown List on Current Reports ScreenCurrent Report Configuration Report Summary ActionChoosing Summary Report Action Summary-Action Output TypesLimitation Report Detailed ActionReport Size Archiving Reports Using This Feature Custom ReportsScheduling Custom ReportsTime-only Schedule Settings Daily Schedule Settings Monthly Schedule Settings Weekly Schedule SettingsCustomer and Company Information Company Information Dialog Report and Template Generation and ManagementCustom Reports Main Modifying Reports Adding ReportsAdding a Report Modifying a Report Deleting ReportsDeleting a Report Modifying Report Templates Report Result Generating ReportsTemplates Manager Modifying a Template Generated Html Report Example Report History Report HistoryLicensing and Administration User Administration for Custom Reports and SOX ReportsReports radio button on the User Administration screen Property Purpose Possible Values DefaultProperty Purpose Possible Values Default1 LimitationsSOX Compliance Reports SOX Reports within Custom Reports ManagerGeneral Setup Instructions Reports and AcronymsCommon Report Header Fields Report Name AcronymCobit Objectives and Setup Requirements History of Privilege Changes Report HPCReport Body Columns HPC Report SampleAbnormal or Unauthorized Changes to Data Report AUC AUC Report SampleAbnormal Use of Service Accounts Report AUS AUS Report SampleAbnormal Termination of Database Activity Report ATD ATD Report SampleSettings Dialog for the EPA Report End of Period Adjustments Report EPAEPA Report Sample Case AssumptionsVerification of Audit Settings Report VAS VAS Report SampleArchiving Reports Licensing and AdministrationReport Size Verification of Audit Settings Report VAS Index