Thread: TRUNCATE privilages visibility in pgAdmin

<font color="#000000" face="verdana" size="4"><font face="arial" size="2">Hello all,<br />I have noticed there is no
possibilityto add/check/revoke TRUCNATE privilege on table using GUI flags. <br />There is no flag TRUNCATE in
privilegelist and it is not visible in SQL script window too.<br />The only way to see TRUNCATE privilege is to check
tableproperties and look for "D" privilage in the ACL.<br /><br />It is not possible to manage this privilage using
PrivilegeWizard (on "Tables" node), but I have noticed it is possible to manage default TRUNCATE privileges for
databaseand schema.<br /><br />pgAdmin 1.14.1 - Windows XP 32bit<br /><br />Regards,<br />Bartek</font></font><br /><br
/><fontcolor="black" face="tahoma" id="f74hd9661xnmbjd7" size="4" style="font-size:12px;color:black">Pozdrawiam, <br
/>Bartek<br/></font> 

Hi,

On Fri, 2011-12-09 at 10:57 +0100, bdmytrak@eranet.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
possibleto 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