List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 31 2002 7:03pm
Subject:Re: Lock Permissions
View as plain text  
At 18:16 +0930 8/31/02, David Lloyd wrote:
>Hmmmm...
>
>( 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 ...

Thread
Lock PermissionsDavid Lloyd31 Aug
  • Re: Lock PermissionsPaul DuBois31 Aug