Re: Truncate Permission - Mailing list pgsql-hackers

From Zeugswetter Andreas ADI SD
Subject Re: Truncate Permission
Date
Msg-id E1539E0ED7043848906A8FF995BDA57902240DB6@m0143.s-mxs.net
Whole thread Raw
In response to Re: Truncate Permission  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: Truncate Permission  (Stephen Frost <sfrost@snowman.net>)
List 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


pgsql-hackers by date:

Previous
From: ohp@pyrenet.fr
Date:
Subject: Re: little PITR annoyance
Next
From: Timasmith
Date:
Subject: one click install?