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
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-
Hi Tiffany,
The Grant format for the Column privilege is a bit confusing ,bit here
it goes:
GRANT (column1,column2, etc...) ON TO
<'username'@'hostname'> IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
f.e
GRANT SELECT (student_id) ON training_db.student TO
'columnuser'@'localhost' IDENTIFIE
