I would add a flag to the record (e.g. 'user_lock'). You then have to evaluate this flag in your application. Or you can wait until 5.0 for triggers where you then can do it in the DB (or maybe not, dunno how far triggers will go).
Maybe MERGE tables could help you, not sure about this though. Split the table in 2 subtables, one part with the user updateable data, the other one with the manager only data. Then grant rights specific to this tables. I do not know however which rights are used: the one you granted to the individual tables or the one you granted to the merge table. You would have to check that out yourself. Cheers /rudy -----Original Message----- From: Dan Ullom [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 19:04 To: [EMAIL PROTECTED] Subject: Single Record Locking - Permanent? Is it possible to lock single records for all but a certain set of users, permanently? The intention is to make old items permanently unchangeable by anyone but managers. Thanks, Dan Ullom TechCentric 314-991-2594 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
