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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

getTablePrivileges() does not report TRUNCATE privilege correctly


  • From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
  • To: pgsql-jdbc(at)postgresql(dot)org
  • Subject: getTablePrivileges() does not report TRUNCATE privilege correctly
  • Date: Fri, 27 Nov 2009 23:40:50 +0100
  • Message-id: <hepkhe$tv4$1@ger.gmane.org> <text/plain>

Hi,

I was seeing an UNKNOWN privilege returned from getTablePrivileges() and the cause for this is the new TRUNCATE privilege. I have a table where the acl looks like this:
{thomas=arwdDxt/thomas,=arwdDxt/thomas}

The D will be translated to "UNKNOWN" in AbstractJdbc2DatabaseMetaData.addACLPrivileges()

The switch simply does not contain an entry for 'D', so the fix should be fairly easy.

I checked this in the sources for 8.4-701


Regards
Thomas





Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group