Thanks for your reply. I repeated your test with the same results on 4.1.21 (database in question is on 4.1). I'll give the ISP another kick and see what they have to say.
So there's no other reason why an ISP might not want to grant LOCK TABLES in a shared hosting environment? Thanks, James >I am not aware of any such bug related to the LOCK TABLES privilege. Like you >I could not find a mention in our bugs database, for any version. > >It is easy to demonstrate that this is not the case. If permissions are >properly set up, LOCK TABLES can be restricted to a database just like every >other priv (makes sense, of course!). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]