Tiffany Wilkes <[EMAIL PROTECTED]> wrote: > > 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.
GRANT UPDATE(pass) ON practicedb.Acct TO 'JohnDoe'@'localhost'; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]