Re: Prevent table delete

From: Thomas Kellerer <FJIFALSDGVAF_at_spammotel.com>
Date: Fri, 17 Aug 2007 21:02:01 +0200
Message-ID: <5im9l8F3bq6s0U1@mid.individual.net>

Brian Peasland wrote on 17.08.2007 20:39:

>> 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.

Interesting. I thought there was a DROP TABLE privilege (which is implicitely granted to the table owner).
Well, if there isn't then my post was obviously rubbish ;)

Thanks for the hint
Thomas Received on Fri Aug 17 2007 - 14:02:01 CDT