I'm glad that worked for you the manual should be updated with clearer examples.. -Martin
Allan Bakke was right! ----- Original Message ----- From: "Tiffany Wilkes" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Tuesday, August 05, 2003 3:48 PM Subject: column privilege problem--Solved > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
