IP Library Granted Patent US 10,108,813
Granted Patent B2
US 10,108,813 · App. 15/431,551 · Granted Oct 23, 2018

Query conditions-based security

Inventors: Richard D. Dettinger (Rochester, MN); Daniel P. Kolz (Rochester, MN)
Assignee: International Business Machines Corporation
G06F21/6227G06F17/3097G06F21/604
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 10,108,813
App. No.
15/431,551
Granted
Oct 23, 2018
Kind
B2
Abstract

A system and article of manufacture for managing access to queries and, more particularly, for managing access by multiple users to persistently stored queries. One embodiment discloses managing access by multiple users to a predefined query against data in a database. The embodiment comprises associating one or more access rights with at least some portion of the predefined query. When a request to access the predefined query by a first user is received, access to the predefined query by the first user is limited on the basis of the access rights.

Claims (48)

1. A non-transitory computer-readable medium containing a program which, when executed by a processor, performs a process of managing access by multiple users to a predefined query against data in a database, the process comprising:

associating one or more access rights with a first portion of the predefined query, wherein the predefined query comprises a textual query composed according to a query language, and wherein the first portion of the predefined query further comprises a substring of the textual query;

receiving, by a query manager application executing on the processor, a request to access the predefined query by a first user, wherein the predefined query and the one or more access rights are stored in a persistent data object;

determining one or more attributes of the first user;

limiting access to the first portion of the predefined query by the first user on the basis of the one or more attributes and the one or more access rights associated with the first portion of the predefined query; and

allowing access to a second portion of the predefined query by the first user, wherein the second portion does not include the first portion.

2. The computer-readable storage medium of claim 1 , wherein limiting access to the predefined query by the first user on the basis of the one or more access rights and the one or more attributes of the first user comprises:

identifying user-specific access rights for the first user from the access rights using the one or more determined attributes, and

wherein access by the first user to some or all of the predefined query is granted on the basis of the user-specific access rights.

3. The computer-readable storage medium of claim 2 , wherein one of the attributes is one of:

(i) a user name;

(ii) a user role; and

(iii) a user authorization level.

4. The computer-readable storage medium of claim 3 , wherein limiting access to the predefined query by the first user on the basis of the access rights and the one or more attributes of the first user comprises allowing the user to make a personal copy of the predefined query.

5. The computer-readable storage medium of claim 4 , wherein limiting access to the predefined query by the first user on the basis of the access rights and the one or more attributes of the first user comprises allowing the user to modify some limited portion of the personal copy.

6. The computer-readable storage medium of claim 4 , wherein the access rights associated with the predefined query are also associated with the personal copy.

7. The computer-readable storage medium of claim 1 , wherein at least one of the one or more access rights limits access to the first portion of the predefined query by one of:

allowing the first user to append query conditions to the query but not modify the first portion; and

preventing the first user from reading the first portion of the predefined query.

8. A non-transitory computer-readable medium containing a program which, when executed by a processor, performs a process of managing access by multiple users to a predefined query against data in a database, the process comprising:

associating one or more access rights with a first portion of the predefined query, wherein the predefined query is an abstract query composed using logical fields defined by a data abstraction model abstractly describing the data in the database, wherein each logical field is mapped to one or more physical entities of an underlying data representation being used in the database, and wherein one of the access rights allows a first user to append query conditions to the query but not modify the first portion;

receiving, by a query manager application executing on the processor, a request to access the predefined query by the first user, wherein the predefined query and the one or more access rights are stored in a persistent data object;

determining one or more attributes of the first user; and

limiting access to the first portion of the predefined query by the first user on the basis of the access rights associated with the first portion of the predefined query and the one or more attributes of the first user, wherein limiting access to the predefined query by the first user on the basis of the access rights and the one or more attributes of the first user comprises allowing the user to make a personal copy of the predefined query and allowing the user to modify the personal copy and wherein the access rights associated with the predefined query are also associated with the personal copy.

9. The computer-readable storage medium of claim 8 , wherein limiting access to the predefined query by the first user on the basis of the access rights and the one or more attributes of the first user further comprises:

identifying user-specific access rights for the first user from the access rights using the one or more determined attributes; and

wherein access by the first user to some or all of the predefined query is granted on the basis of the user-specific access rights.

10. The computer-readable storage medium of claim 8 , wherein the one or more attributes is at least one of:

(i) a user name;

(ii) a user role; and

(iii) a user authorization level.

11. The computer-readable storage medium of claim 8 , wherein one type of access right prevents a second user from reading the first portion of the predefined query.

12. The computer-readable storage medium of claim 8 , wherein one type of access right allows a second user to read and modify the first portion of the predefined query.

13. The computer-readable storage medium of claim 8 , wherein one type of access right prevents the first user from reading the first portion of the predefined query.

14. A non-transitory computer-readable medium containing a program which, when executed by a processor, performs a process of managing access by multiple users to a predefined query against data in a database, the process comprising:

creating access rights configured for restricting access to a first portion of the predefined query wherein the predefined query is an abstract query composed using logical fields defined by a data abstraction model abstractly describing the data in the database, wherein each logical field is mapped to one or more physical entities of an underlying data representation being used in the database;

associating the access rights with the predefined query, wherein the predefined query and the one or more access rights are stored in a persistent data object;

granting, by a query manager application executing on the processor, access to a first user to the first portion of the predefined query on the basis of the access rights and on the basis of one or more attributes of the first user, wherein one of the access rights allows the first user to append query conditions to the query but not modify the first portion and wherein the access granted to the predefined query by the first user on the basis of the access rights and the one or more attributes of the first user allows the first user to make a personal copy of the predefined query and allows the user to modify the personal copy; and

allowing the first user to modify the access rights associated with the personal copy of the predefined query.

15. The computer-readable storage medium of claim 14 , the process further comprising:

receiving a request for accessing the predefined query from the first user;

presenting the predefined query to the first user on the basis of the access rights; and

displaying, to the first user, an indication of the access rights of the first user.

16. The computer-readable storage medium of claim 14 , the process further comprising:

receiving a request for accessing the predefined query from the first user; and

presenting the predefined query to the first user on the basis of the access rights, wherein at least one query condition of the predefined query is not presented in the predefined query.

17. The computer-readable storage medium of claim 14 , wherein associating the access rights with the predefined query comprises:

storing the predefined query and the access rights as a persistent data object.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Feb 14, 2017
From: DETTINGER, RICHARD D.; KOLZ, DANIEL P.
To: INTERNATIONAL BUSINESS MACHINES CORPORATION
Reel/Frame 041248/0306 →
Continuity (3)
Continuation 12748616 · Mar 29, 2010
Continuation 10897335 · Jul 22, 2004
Related Publication 20170161514A1 · Jun 8, 2017