Postgres Pro
Downloads
Home   >   mailing lists

Re: truncating table permissions - Mailing list pgsql-sql

From Tom Lane
Subject Re: truncating table permissions
Date
Msg-id 14190.1109998939@sss.pgh.pa.us
Whole thread Raw
In response to truncating table permissions  ("Lynwood Stewart" <lynwood@nwlink.com>)
List pgsql-sql
Tree view 
"Lynwood Stewart" <lynwood@nwlink.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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: date - date returns integer?
Next
From: Thomas Mueller
Date:
Subject: Re: Simple delete takes hours