Re: Truncate Permission - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Truncate Permission
Date
Msg-id 20070611114920.GQ7531@tamriel.snowman.net
Whole thread Raw
In response to Re: Truncate Permission  ("Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>)
Responses Re: Truncate Permission  ("Nicholas Barr" <nicky@chuckie.co.uk>)
List pgsql-hackers
* Zeugswetter Andreas ADI SD (ZeugswetterA@spardat.at) wrote:
>
> > > 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.

Nope, it doesn't follow MVCC rules properly either.  It really needs to
be a seperate permission.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Timasmith
Date:
Subject: one click install?
Next
From: Michael Meskes
Date:
Subject: Re: ecpg leaves broken files around