Re: Prevent table delete

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Fri, 17 Aug 2007 13:39:18 -0500
Message-ID: <46c5df4b$0$32552$88260bb3@free.teranews.com>

Thomas Kellerer wrote:
>
>
> 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.

Did you mean the DROP ANY TABLE system privilege? There is no DROP TABLE system privilege.

> 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

The owner of the table always has the rights to drop their own tables. How does he grant the right to drop the table to himself?

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com

Received on Fri Aug 17 2007 - 13:39:18 CDT