The Grant format for the Column privilege is a bit confusing ,bit here it goes:
GRANT <privilege> (column1,column2, etc...) ON <dbname.tblname> TO <'username'@'hostname'> IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
f.e
GRANT SELECT (student_id) ON training_db.student TO 'columnuser'@'localhost' IDENTIFIED BY 'columnuser';
Best regards
Nils Valentin Tokyo/Japan
Dathan Vance Pattishall wrote:
FYI Note on this. Using column privs you take a performance penalty on reads / writes.
-->-----Original Message----- -->From: Tiffany Wilkes [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, August 05, 2003 3:48 PM -->To: mysql -->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]
