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?
