At 18:16 +0930 8/31/02, David Lloyd wrote:
>( 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.
The privilege tables have changed in 4.0.2. Two of the new privileges are
CREATE TEMPORARY TABLES and LOCK TABLES. However, these are not granted
at the database level, but only at the global level, so they are not
granted with GRANT ALL ON db_name.* TO ...
You must grant them explicitly with:
GRANT CREATE TEMPORARY TABLES,LOCK TABLES ON *.* to ...
|• Lock Permissions||David Lloyd||31 Aug|
| • Re: Lock Permissions||Paul DuBois||31 Aug|