You don't.
Privileges can be set for a column in a table, but not by record.
Mark van Brenk wrote:
>
> Greetings, and I'm sorry if this is a topic that's already been covered, but I've
>read over about 100 of the past mails and can't find something similar.
>
> How do I GRANT UPDATE to specific columns in specific records?
>
> Example:
>
> I've got a table "u" which covers complete data on each user for the group I
>administer the database for. I want to grant users the ability to update certain
>items in their rows, however, want their user/password to ONLY update that row.
>
> I've got GRANT UPDATE (fname, lname, email, etc.) ON tsf.u etc. However, I want to
>issue the criteria similar to.. GRANT UPDATE (fname, lname, email WHERE u.uID=10) -
>10 being that user's ID number.
>
> The WHERE clause doesn't work (or maybe I've using the wrong syntax).. any help?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
