On Mon, Jun 11, 2007 at 09:40:08AM +0200, Ewald Geschwinde wrote: > My problem is that some users don't have access to change the structure but > they wanted to delete all data from the table > they try truncate - does not work because not the owner > so they make a delete from a really big table
Wouldn't it be far more logical to decide that if a user has the permissions to do a DELETE FROM table; then they have permission to do a TRUNCATE? Why make an additional permission? Have a nice day, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature