Horton

Re: Must be owner to truncate?

Manfred Koizar <mkoi-pg@aon.at>

View thread
From: Manfred Koizar <mkoi-pg@aon.at>
To: Andreas Seltenreich <andreas+pg@gate450.dyndns.org>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, Stephen Frost <sfrost@snowman.net>, "Jim C. Nasby" <decibel@decibel.org>, Tom Lane <tgl@sss.pgh.pa.us>, Postgres Hackers <pgsql-hackers@postgresql.org>
Date: 2005-08-24T12:29:22Z
Lists: 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.

Servus
 Manfred