Invention Grant
- Patent Title: Query servicing with access path security in a relational database management system
-
Application No.: US13681965Application Date: 2012-11-20
-
Publication No.: US10169491B2Publication Date: 2019-01-01
- Inventor: John Kliewe
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Schmeiser, Olsen & Watts, LLP
- Agent Michael Petrocelli
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A method and system for servicing a data query in a relational database management system (RDBMS). Access path security corresponding to a user originating the data query is configured. The data query requests data from the RDBMS pursuant to a received configuration query associated with the user. The data query requests a value stored in a result field by specifying the result field and a result table of a database in the RDBMS. The configuration query specifies a usable index field associated with the result table. The access path security mandates the user to provide a search key in the data query in searching the result table. The search key includes a name identical to the usable index field specified in the configuration query such that the access path security enables users to search the result table only when the users specify the usable index field in the data query.
Public/Granted literature
- US20130080466A1 QUERY SERVICING WITH ACCESS PATH SECURITY IN A RELATIONAL DATABASE MANAGEMENT SYSTEM Public/Granted day:2013-03-28
Information query