Re: Must be owner to truncate? - Mailing list pgsql-hackers

From Manfred Koizar
Subject Re: Must be owner to truncate?
Date
Msg-id mkpog1982o9fn9qfmq8q9sf0jvlq04j5p3@4ax.com
Whole thread Raw
In response to Re: Must be owner to truncate?  (Andreas Seltenreich <andreas+pg@gate450.dyndns.org>)
Responses Re: Must be owner to truncate?
List pgsql-hackers
On Wed, 24 Aug 2005 07:01:00 +0200, Andreas Seltenreich
<andreas+pg@gate450.dyndns.org> wrote:
>However, a question arose quickly: According to the standard, revoking
>INSERT, UPDATE and DELETE after GRANT ALL PRIVILEGES would leave the
>relation read-only, but with the TRUNCATE privilege lying around, this
>would no longer be true for PostgreSQL.

I'd say that the TRUNCATE privilege includes DELETE, so that REVOKE
DELETE implicitly revokes TRUNCATE and GRANT TRUNCATE implicitly
grants DELETE.

ServusManfred



pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: Re: 8.1 release notes
Next
From: Stephen Frost
Date:
Subject: Re: Must be owner to truncate?