Can you do a show grants for [EMAIL PROTECTED] for both users and see if there is a glaring difference in permissions?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/27/04, 12:33:56 PM, "Tucker," Gabriel <[EMAIL PROTECTED]> wrote regarding RE: Privileging: > Yes - the same machine... > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, February 27, 2004 11:03 AM > To: Tucker, Gabriel > Cc: [EMAIL PROTECTED] > Subject: Re: Privileging > Are you running this test from the same machine for both users? > >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< > On 2/27/04, 9:55:03 AM, "Tucker," Gabriel <[EMAIL PROTECTED]> wrote > regarding Privileging: > > 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. > > 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 > > ********************************************************* > > "The jokes on him, I'll be dead by then" - HJS > > Gabe Tucker > > Bloomberg LP > > P 609 750 6668 > > F 646 268 5681 > > ********************************************************* > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
