According to the documentation, http://www.postgresql.org/docs/current/interactive/sql-truncate.html
, only the owner can truncate a table. Which means the non-owner must either log in/ switch roles as
the owner, or they can just run a DELETE.
> Hello all,
> I am trying to GRANT truncate permissions to a non-owner of table and it's
> not allowing me to:
> GRANT TRUNCATE ON stage01 TO jaime44;
> ERROR: unrecognized privilege type "truncate"
> How do I grant said permission?
> View this message in context:
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
In response to
pgsql-general by date
|Next:||From: Ryan Wallace||Date: 2008-07-28 19:53:08|
|Subject: Creating a comprehensive search that queries multiple tables|
|Previous:||From: Tom Lane||Date: 2008-07-28 19:42:14|
|Subject: Re: Must be table owner to truncate? |