MySQL Forums
Forum List  »  MySQL Administrator

Re: Restricting number of records in a single query
Posted by: Ronan Cashell
Date: April 22, 2011 04:41PM

Have you thought about creating a stored procedure for each query? You provide execute permission so that the table is not available to the user but can only obtain the information through the execution of the stored procedure. In the stored procedure you limit the number of rows.

Ronan Cashell
Senior Oracle/MySQL Administrator
IT Integrated Business Solutions
http://www.it-iss.com

Options: ReplyQuote


Subject
Written By
Posted
Re: Restricting number of records in a single query
April 22, 2011 04:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.