COMPOSING ABSTRACT QUERIES FOR DELEGATED USER ROLES
First Claim
1. A computer-implemented method for composing an abstract query, comprising:
- receiving a selection, from a set of predefined user roles, of a plurality of user roles to be provided access to the abstract query, wherein the set of predefined user roles is defined in an abstraction model that defines logical fields that model underlying physical data in a manner making a schema of the physical data transparent to a user of the abstraction model;
for each of the plurality of user roles, determining a group of permitted logical fields to which access is permitted for the user role;
presenting, in a query interface, a plurality of the logical fields, at least a portion of the logical fields being designated with an indication of which group the respective logical field belongs to;
receiving a selection, from the plurality of logical fields, of one or more logical fields to be included in the abstract query; and
composing the abstract query using the one or more logical fields.
2 Assignments
0 Petitions
Accused Products
Abstract
Embodiments of the invention provide a database administrator composing an abstract query with visibility to logical fields that are permitted for the delegated roles. In one embodiment, a query interface is configured to receive administrator selections of delegated roles (i.e., the user roles to be provided with access to the finished abstract query). The query interface may then present the administrator with logical fields that are permitted for each delegated role. Providing such information may enable the administrator to verify that all intended users will have access to the finished abstract query.
15 Citations
21 Claims
-
1. A computer-implemented method for composing an abstract query, comprising:
-
receiving a selection, from a set of predefined user roles, of a plurality of user roles to be provided access to the abstract query, wherein the set of predefined user roles is defined in an abstraction model that defines logical fields that model underlying physical data in a manner making a schema of the physical data transparent to a user of the abstraction model; for each of the plurality of user roles, determining a group of permitted logical fields to which access is permitted for the user role; presenting, in a query interface, a plurality of the logical fields, at least a portion of the logical fields being designated with an indication of which group the respective logical field belongs to; receiving a selection, from the plurality of logical fields, of one or more logical fields to be included in the abstract query; and composing the abstract query using the one or more logical fields. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A computer-readable storage medium containing a program which, when executed, performs an operation, comprising:
-
receiving a selection, from a set of predefined user roles, of a plurality of user roles to be provided access to an abstract query, wherein the set of predefined user roles is defined in an abstraction model that defines logical fields that model underlying physical data in a manner making a schema of the physical data transparent to a user of the abstraction model; for each of the plurality of user roles, determining a group of permitted logical fields to which access is permitted for the user role; presenting, in a query interface, a plurality of the logical fields, at least a portion of the logical fields being designated with an indication of which group the respective logical field belongs to; receiving a selection, from the plurality of logical fields, of one or more logical fields to be included in the abstract query; and composing the abstract query using the one or more logical fields. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. A system, comprising:
-
a processor; and a memory containing a program configured to perform an operation, comprising; receiving a selection, from a set of predefined user roles, of a plurality of user roles to be provided access to an abstract query, wherein the set of predefined user roles is defined in an abstraction model that defines logical fields that model underlying physical data in a manner making a schema of the physical data transparent to a user of the abstraction model; for each of the plurality of user roles, determining a group of permitted logical fields to which access is permitted for the user role; presenting, in a query interface, a plurality of the logical fields, at least a portion of the logical fields being designated with an indication of which group the respective logical field belongs to; receiving a selection, from the plurality of logical fields, of one or more logical fields to be included in the abstract query; and composing the abstract query using the one or more logical fields. - View Dependent Claims (16, 17, 18, 19, 20, 21)
-
Specification