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...
>
>
>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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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 you'll share with me one love, one lifetime
 Lead me, save me from my solitude.
Say you'll want me with you, here beside you
 Anywhere you go let me go too... (Webber/Hart/Black)

-
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php