Hello
I have a user that is granted all privileges for their database. When they run a select * on a table in that database, the request fails after about 1000 records. When I run the same query as root, I have no problems. Consequently, I believe this is a permissioning problem.
The other user may be running with the --safe-updates or --i-am-a-dummy option. This restricts DELETE/UPDATE, but also keeps SELECT from returning large result sets.
What program are you using to issue the query?
Since I have granted this user all privileges on their database, I am not sure what could be wrong.
I appreciate any assistance.
4.0.16 - Unix
Thanks - Gabe
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
