List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:April 23 2001 3:44pm
Subject:Re: Criteria in the GRANT command
View as plain text  
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?
Criteria in the GRANT commandMark van Brenk23 Apr
  • Re: Criteria in the GRANT commandGerald Clark23 Apr