Re: Is it possible to have Undeletable Records?

[Michael Ayers]

Wesley Furgiuele wrote:
I don't think so. I think your current method of either storing it in
the query or with a boolean field is your best bet. What I've seen
done in the past is that records get marked with a user level and
there is either one or a group of users who are allowed to delete  or
modify those otherwise permanent records.
Wes
On Fri, 03 Sep 2004 11:38:35 +0100, zzapper <[EMAIL PROTECTED]> wrote:
 

Hi Y'All
Is it possible to have undeletable/unmodifiable  records in a table of otherwise 
modifiable &
deleteable & createable records?
At present I do it at the Update/Delete level where I have clauses which prevent 
certain records
being changed. I suppose I could also have an extra boolean field "Record Read only", 
but is there
anyway to specify at the data level?
zzapper (vim, cygwin, wiki & zsh)
--
vim -c ":%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg?"
http://www.vim.org/tips/tip.php?tip_id=305  Best of Vim Tips
   

 

Here is an off the wall idea. 
Create a MERGE table for the data. 
Put the undeletable data into one table then pack it. 
Put the other data into a normal myisam file.
I have no idea if this will work.  But I think it is worth a try.
Good Luck


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]