----- Original Message ----- From: "Jesse W. Asher" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 22, 2004 6:34 AM Subject: Having rows or fields that can't be modified once entered.
> > I was wondering if there was some builtin mechanism I could use to > ensure that a field or row in my database could not be altered after it > was initially inserted. Is there anything in the database that would > allow this type of functionality? Thanks!! > Have a look at the GRANT statement at http://dev.mysql.com/doc/mysql/en/GRANT.html. As long as no one is given any Insert, Update, or Delete privilege on the table, your table should be safe against changes. Important note: The 'ALL' privilege will give the Insert, Update, and Delete privileges - and others - to your users so be sure you haven't granted Insert, Update, or Delete explicitly to anyone at either the table or column level, and be sure you haven't granted All to anyone explicitly and you should achieve the desired effect. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
