Re: Lock Permissions

2002-08-31 Thread Paul DuBois
At 18:16 +0930 8/31/02, David Lloyd wrote: >H... > >( mysql, query ) > >What permissions does a user need to issue: > >LOCK TABLES blah WRITE > >??? > >I have a user which I have: > >GRANT ALL ON * TO user (blah blah) > >...but that user can't lock any tables. Only the mysql root user can... >

Lock Permissions

2002-08-31 Thread David Lloyd
H... ( mysql, query ) What permissions does a user need to issue: LOCK TABLES blah WRITE ??? I have a user which I have: GRANT ALL ON * TO user (blah blah) ...but that user can't lock any tables. Only the mysql root user can... Version 4.0.2, built from source on RH 7.1. DSL -- Say