Обсуждение: 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