[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Lock Permissions
From:       Paul DuBois <paul () snake ! net>
Date:       2002-08-31 19:03:08
[Download RAW message or body]

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 ...


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread118493@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-mysql=progressive-comp.com@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

[prev in list] [next in list] [prev in thread] [next in thread]