Patent ID: 8364714
Filing Date: 2013-01-29
Classification: G06F

Abstract:
1. A method for servicing a data query with access path security in a relational database management system (RDBMS), said method comprising: configuring access path security corresponding to a user originating the data query requesting data stored in the RDBMS pursuant to a configuration query associated with the user received from an administrator of the RDBMS, receiving the data query from the user of the RDBMS; calculating, by a processor of the computer system, an access path for the data query based on search specification of the data query, wherein the search specification is selected from a group consisting of the search key and the search condition; determining that the access path security from said configuring authorizes the user to use the calculated access path for servicing the data query; retrieving the data requested by the data query responsive to searching the database for the value of the result field only via the calculated access path for the data query; and returning the retrieved data from said retrieving to the user.