column privilege problem

[Tiffany Wilkes]

Hi,

I am having problems granting column privileges. I want to grant the
update privilege (only) to a column (called pass) in a table (called
Acct). Here's what I get:

mysql> grant update pass on practicedb.Acct to JohnDoe@localhost;
ERROR 1064: You have an error in your SQL syntax near 'pass on
practicedb.Acct to JohnDoe@localhost' at line 1

I don't understand how the syntax is wrong. I think I followed the
instructions in the manual. I don't have any problems granting table
privileges--just column.

Tiffany Landry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw