Invention Grant
- Patent Title: Automatic SQL query modification for data restriction
-
Application No.: US14738539Application Date: 2015-06-12
-
Publication No.: US09911001B2Publication Date: 2018-03-06
- Inventor: Gary J. Bisaga
- Applicant: Pearson Education, Inc.
- Applicant Address: US NY New York
- Assignee: PEARSON EDUCATION, INC.
- Current Assignee: PEARSON EDUCATION, INC.
- Current Assignee Address: US NY New York
- Agency: Kilpatrick Townsend & Stockton LLP
- Main IPC: H04L29/06
- IPC: H04L29/06 ; G06F21/62 ; G06F17/30

Abstract:
A method of automatically modifying a computer data query is disclosed herein. The modification of the computer data query can be performed to restrict access to data. The computer data query can be modified by receiving the computer data query, identifying tables in the query and retrieving providers associated with the tables identified in the query. These providers can be linked to one or several predicates. These predicates can be retrieved and used to modify the query. The modified query can then be used to retrieve data from one or several tables identified within the query.
Public/Granted literature
- US20160364444A1 AUTOMATIC SQL QUERY MODIFICATION FOR DATA RESTRICTION Public/Granted day:2016-12-15
Information query