PROTECTED HANDLING OF DATABASE QUERIES
First Claim
1. A method for querying database system views and tables, the method comprising:
- receiving a user query from a user, the user query being directed to one or both of a view and a table of a database, wherein the user is not a database administrator;
parsing the user query with a query parser to identify elements of the user query, parsing the query including determining whether the query meets certain database access criteria;
automatically generating a database query based on the parsing of the user query, the generation of the database query including generating a database query that is limited by the database access criteria;
accessing the one or both of the view and the table using the generated database query, wherein the access is limited to read-only access; and
obtaining a result of the access of the one or both of the view and table.
1 Assignment
0 Petitions
Accused Products
Abstract
Embodiments regard protected handling of database queries. An embodiment of a method for querying database system views and tables includes: receiving a user query from a user, the user query being directed to one or both of a view and a table of a database, wherein the user is not a database administrator; parsing the user query with a query parser to identify elements of the user query, parsing the query including determining whether the query meets certain database access criteria; automatically generating a database query based on the parsing of the user query, the generation of the database query including generating a database query that is limited by the database access criteria; accessing the one or both of the view and the table using the generated database query, wherein the access is limited to read-only access; and obtaining a result of the access of the one or both of the view and table.
-
Citations
30 Claims
-
1. A method for querying database system views and tables, the method comprising:
-
receiving a user query from a user, the user query being directed to one or both of a view and a table of a database, wherein the user is not a database administrator; parsing the user query with a query parser to identify elements of the user query, parsing the query including determining whether the query meets certain database access criteria; automatically generating a database query based on the parsing of the user query, the generation of the database query including generating a database query that is limited by the database access criteria; accessing the one or both of the view and the table using the generated database query, wherein the access is limited to read-only access; and obtaining a result of the access of the one or both of the view and table. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. An apparatus for querying database system views and tables, the apparatus comprising:
-
an interface for receipt of queries of databases, the interface including a query parser to parse received queries; a processor to process data, including data for database queries; and a memory for storage of data; wherein the system is to automatically; receive from a user a user query directed to one or both of a view and a table of a database, wherein the user is not a database administrator; parse the user query with the query parser to identify elements of the user query, parsing the query including determining whether the query meets certain database access criteria; generate a database query based on the parsing of the user query, the generation of the database query including generating a database query that is limited by the database access criteria; access the one or both of the view and the table based on the query, wherein the access is limited to read-only access; and obtain a result of the access of the one or both of the view and table. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19, 20)
-
-
21. A non-transitory computer-readable storage medium having stored thereon data representing sequences of instructions that, when executed by a processor, cause the processor to perform operations comprising:
-
receiving a user query from a user, the user query being directed to one or both of a view and a table of a database, wherein the user is not a database administrator; parsing the user query with a query parser to identify elements of the user query, parsing the query including determining whether the query meets certain database criteria; automatically generating a database query based on the parsing of the user query, the generation of the database query including generating a database query that is limited by the database access criteria; accessing the one or both of the view and the table using the generated database query, wherein the access is limited to read-only access; and obtaining a result of the access of the one or both of the database system view and database system table. - View Dependent Claims (22, 23, 24, 25, 26, 27, 28, 29, 30)
-
Specification