Patent ID: 7885976

Claim:
A method for limiting access to data in a database, the method comprising: receiving at least one new query for data from at least one user; rewriting the at least one new query to form a rewritten query including a Fetch First n Rows Only (FFnRO) clause with a value n representing a number of rows to be returned from the rewritten query against data in the database running the rewritten query against the data to return only results located in the number of rows specified by at least one of a maximum instantaneous rate of a data flow, the value n set is based on one or more access rights associated with the user when accessing data in the database, and a maximum cumulative volume of data associated with the user when accessing data in the database, the value of n is based on one or more access rights associated with the user, and a maximum cumulative volume value less any number of row previously fetched over a specified period of time.