Example of Chaining to a PL/SQL-based Pudr | Fortinet FortiDB

Chaining with Parameterized User-Defined Rules

Rule Chaining

Chaining the UBM Policy and PUDR Together

Associating a Source Rule That Can Pass parameters with a PUDR

Example of Chaining to a PL/SQL-based PUDR

In this Oracle PL/SQL kill-session example, we:

1Create a DB user, BAD_GUY, whose session we will monitor, in our Oracle target database.

Item Setting for Session Policy

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

Image 16

Fortinet FortiDB manual Example of Chaining to a PL/SQL-based Pudr, Item Setting for Session Policy

Contents

Utilities User Guide FortiDB Utilities User Guide Trademarks Table of Contents Index FortiDB MA Utilities Auto Discovery Selecting Addresses for Auto-Discovery Selecting Non-Standard Ports for Auto-Discovery Results from Auto-Discovery MS-SQL Discovered Database Information Populating Connection Form MS-SQL Connection Summary Connection Summary Button Connection Summary Output Rule Chaining Setting Screen Rule Chaining Rule Chaining Chaining with Parameterized User-Defined Rules Parameterized User-Defined Rule Flow Diagram General Pudr Steps Disabled Parameter Checkboxes Validating the Pudr before Saving Item Setting for Session Policy Example of Chaining to a PL/SQL-based Pudr Policy 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 Example Rule 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 Schedule Setting a Combined Schedule Setting a Randomized IntervalSetting a Calendar-Based Schedule Setting a Randomized Interval Reporting by Time Enabling Email RecipientsSpecifying Report Parameters ARM Reporting by Time ARM Reporting by Time Calendar Pop-up New Report Setting Screen top New Reports Menu New Report Setting Screen bottom Saved and Enabled Report Using the Select Checkbox to Affect Multiple Reports Activating ARM Running and Analyzing ReportsStatus Menu Status Dialog View Reports Dropdown List on Current Reports Screen Current Report Configuration Report Summary ActionChoosing Summary Report Action Summary-Action Output Types Limitation Report Detailed ActionReport Size Archiving Reports Using This Feature Custom ReportsScheduling Custom Reports Time-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 History Licensing and Administration User Administration for Custom Reports and SOX ReportsReports radio button on the User Administration screen Property Purpose Possible Values Default Property Purpose Possible Values Default1 Limitations SOX Compliance Reports SOX Reports within Custom Reports Manager General Setup Instructions Reports and AcronymsCommon Report Header Fields Report Name Acronym Cobit Objectives and Setup Requirements History of Privilege Changes Report HPCReport Body Columns HPC Report Sample Abnormal or Unauthorized Changes to Data Report AUC AUC Report Sample Abnormal Use of Service Accounts Report AUS AUS Report Sample Abnormal Termination of Database Activity Report ATD ATD Report Sample Settings Dialog for the EPA Report End of Period Adjustments Report EPAEPA Report Sample Case Assumptions Verification of Audit Settings Report VAS VAS Report Sample Archiving Reports Licensing and AdministrationReport Size Verification of Audit Settings Report VAS Index