Skip site navigation (1) Skip section navigation (2)

Re: Must be table owner to truncate?

From: Said Ramirez <sramirez(at)vonage(dot)com>
To: smiley2211 <msramsey22(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Must be table owner to truncate?
Date: 2008-07-28 19:45:05
Message-ID: 488E21C1.8050900@vonage.com (view raw or flat)
Thread:
Lists: pgsql-general
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.
   -Said

smiley2211 wrote:
> 
> 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?
> 
> Thanks...Michelle.
> 
> --
> View this message in context: 
> http://www.nabble.com/Must-be-table-owner-to-truncate--tp18697753p18697753.html
> 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:
> http://www.postgresql.org/mailpref/pgsql-general
> 

In response to

Responses

pgsql-general by date

Next:From: Ryan WallaceDate: 2008-07-28 19:53:08
Subject: Creating a comprehensive search that queries multiple tables
Previous:From: Tom LaneDate: 2008-07-28 19:42:14
Subject: Re: Must be table owner to truncate?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group