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

Must be table owner to truncate?

From: smiley2211 <msramsey22(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Must be table owner to truncate?
Date: 2008-07-28 19:36:11
Message-ID: (view raw or whole thread)
Lists: pgsql-general
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


pgsql-general by date

Next:From: Alvaro HerreraDate: 2008-07-28 19:40:53
Subject: Re: array_accum() and quoted content
Previous:From: aravind chanduDate: 2008-07-28 19:30:34
Subject: How to give input a file for a stored procedure

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