Re: TRUNCATE privilages visibility in pgAdmin

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: "bdmytrak(at)eranet(dot)pl" <bdmytrak(at)eranet(dot)pl>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: TRUNCATE privilages visibility in pgAdmin
Date: 2011-12-10 14:19:49
Message-ID: 1323526789.2294.4.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

On Fri, 2011-12-09 at 10:57 +0100, bdmytrak(at)eranet(dot)pl wrote:
[...]
> I have noticed there is no possibility to add/check/revoke TRUCNATE privilege on table using GUI flags.
> There is no flag TRUNCATE in privilege list and it is not visible in SQL script window too.
> The only way to see TRUNCATE privilege is to check table properties and look for "D" privilage in the ACL.
> It is not possible to manage this privilage using Privilege Wizard (on "Tables" node), but I have noticed it is possible to manage default TRUNCATE privileges for database and schema.
> pgAdmin 1.14.1 - Windows XP 32bit

You're right. I guess we forgot to support the new TRUNCATE permission
(new as in "new in 8.4"... ugh...).

I just commited a patch to have that in the next release.

Thanks for reminding us about this permission.

Regards.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2011-12-10 18:28:41 Re: pgadmin error - sql window
Previous Message Vjacheslav A. 2011-12-10 11:53:04 pgadmin - problems with servers treeview