beautypg.com

User-defined rules by rdbms, Pl/sql user-defined rules (oracle) – Fortinet FortiDB User Manual

Page 29

background image

User-Defined Rules

User-Defined Rules by RDBMS

FortiDB Version 3.2 Privilege Monitor User Guide
15-32000-81364-20081219

27

• Item Status (is it Enabled, and therefore to be monitored).

• Guarded Item Description (the name of the item)

For details on changing UDR (Guarded Item) Settings, please refer to

Changing

UDR Settings

.

User-Defined Rules by RDBMS

This section explains User-Defined Rules by Oracle PL/SQL, Transact SQL for
MS SQL Server, and SQL Procedural Language for DB2.

PL/SQL User-Defined Rules (Oracle)

Adding a PL/SQL Rule

Example:

declare
tnumber number;
v_number number;
function test return number
is
begin

select empno into tnumber from scott.emp where

empno=7900;

return tnumber;

end;
begin