Patent · US Active

Method for monitoring stored procedures

US8056141B2 · kind B2 · utility

21Cited by
12References
16Claims
0Family size

Assignee

Inventors

Key dates

Filing dateSep 13, 2007
Grant dateNov 8, 2011
Priority date
Expiry dateJul 5, 2030

Classification

  • Technology area (CPC G)Physics
  • CPC primaryG06F21/552
  • WIPO fieldComputer technology
  • WIPO sectorElectrical engineering

Abstract

A method for monitoring stored procedures is disclosed. The method performs on-line and inline monitoring of stored procedures for detecting table access operations performed by the procedures. This allows the enforcing of access control policies, correlation rules and audit rules on stored procedures. The monitoring is performed using mapping information gathered about each stored procedure that can be executed by a database server. The method comprises parsing an incoming transaction submitted by a client; determining whether the incoming transaction includes an invocation of a stored procedure; obtaining a query group corresponding to the stored procedure; applying an access control policy on the query group; and asserting an unauthorized event if the query group is not compliant with the access control policy.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.