System and method for restricting access to a data table within a database
US6336114B1 · kind B1 · utility
Assignee
Inventor
Key dates
| Filing date | Sep 3, 1998 |
| Grant date | Jan 1, 2002 |
| Priority date | — |
| Expiry date | Sep 3, 2018 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99939
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
The system and associated method utilizes a client computer (client), a server computer (server), and a database system. The client establishes communication with the server and submits a request for data to the server. The server receives the request and retrieves data from a column within a table of the database system in response to the request. The server then determines which rows within the column can be accessed by a user of the client. In this regard, the server includes a security information table having predefined values that indicate which rows of information within the database system are accessible to the user. The server analyzes these values in order to determine whether the user is authorized to access a particular row. The server then discards data associated with rows that the user is not authorized to access and transmits the remaining data to the client.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.