column privilege problem--Solved

[Tiffany Wilkes]

 I solved the problem--I needed ( ) around the column list.  I think 
the manual should make that more clear.

-------- Original Message --------
Subject: column privilege problem
Date: Tue, 05 Aug 2003 15:39:54 -0700
From: Tiffany Wilkes <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]


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 [EMAIL PROTECTED];
ERROR 1064: You have an error in your SQL syntax near 'pass on 
practicedb.Acct to [EMAIL PROTECTED]' 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/[EMAIL PROTECTED]




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]