Re: Prevent table delete

"Thomas Kellerer" <FJIFALSDGVAF_at_spammotel.com> a écrit dans le message de news: 5iluotF3piq0pU1_at_mid.individual.net...
|
|
| Sean wrote on 17.08.2007 17:28:
| > how do i create a table which cant be deleted by the normal drop
| > command.
| >
| > a friend told me that by hiding the table file it cant be deleted. is
| > there any other way?
| >
|
| I have *no* idea what you mean with "table file", but revoking the DROP
| privilege from all users that are able to access the table should be enough.
|
| The only drawback is, that the owner of the table can grant himself the right to
| drop the table. But he won't be able to drop it accidently
| Thomas
|

You can do it with a database trigger "before drop" that raises an error if you want to drop this table.

Regards
Michel Cadot Received on Fri Aug 17 2007 - 11:33:22 CDT