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: 18697753.post@talk.nabble.com (view raw or flat)
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?

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.


Responses

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-2014 The PostgreSQL Global Development Group