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?
> 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?