Re: Truncate Permission

From: "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
To: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, "Martijn van Oosterhout" <kleptog(at)svana(dot)org>
Cc: "Ewald Geschwinde" <egeschwinde(at)gmail(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Nick Barr" <nicky(at)chuckie(dot)co(dot)uk>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Truncate Permission
Date: 2007-06-11 09:44:09
Message-ID: E1539E0ED7043848906A8FF995BDA57902240DB6@m0143.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> > 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?
>
> Truncate doesn't fire ON DELETE triggers.

Yes, but it would imho be ok if there are'nt any on delete triggers on
the table.

Andreas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Timasmith 2007-06-11 11:38:55 one click install?
Previous Message ohp 2007-06-11 09:35:49 Re: little PITR annoyance