Re: truncating table permissions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lynwood Stewart" <lynwood(at)nwlink(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: truncating table permissions
Date: 2005-03-05 05:02:19
Message-ID: 14190.1109998939@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Lynwood Stewart" <lynwood(at)nwlink(dot)com> writes:
> I was expecting "truncate table <tablename>" to truncate a table if I had
> delete permissions. This does not appear to be the case.

No, TRUNCATE is restricted to the table's owner, regardless of any
grantable permissions.

This was (ahem) inadequately documented until very recently.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Mueller 2005-03-05 14:00:46 Re: Simple delete takes hours
Previous Message Tom Lane 2005-03-05 04:36:20 Re: date - date returns integer?