List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 24 1999 11:24pm
Subject:Re: [Q] tables_priv ...
View as plain text  
At 3:55 PM -0700 5/24/1999, Thimble Smith wrote:
>On Mon, May 24, 1999 at 10:28:12AM -0600, Sasha Pachev wrote:
>> Actually, mysql does not support priviliges on the table level.
>> If you want to accomplish what you are describing, you need to
>> move your tables into different databases.
>
>This is not correct.  MySQL has a fully functioning GRANT command
>which lets you specify privileges on the table and on the column
>level!  Look at the ``GRANT and REVOKE syntax'' section in the
>manual.  You need to have a recent version of MySQL for this to
>work (>= 3.22.11, I think).

3.22.11 is correct, but it's best to use 3.22.12 or higher
if possible.  3.22.11 had a bug which treated column names in
GRANT in case-sensitive fashion.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
[Q] tables_priv ...Zeus V Panchenko24 May
  • Re: [Q] tables_priv ...Sasha Pachev24 May
    • Re: [Q] tables_priv ...Thimble Smith25 May
      • Re: [Q] tables_priv ...Paul DuBois25 May