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/