Re: getTablePrivillages giving wrong privillages

From: Kris Jurka <books(at)ejurka(dot)com>
To: Altaf Malik <mmalik_altaf(at)yahoo(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: getTablePrivillages giving wrong privillages
Date: 2006-02-01 17:23:32
Message-ID: Pine.BSO.4.61.0602011222240.4903@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Wed, 1 Feb 2006, Altaf Malik wrote:

> I created a table PRIV_TEST with two columns and granted "SELECT" and
> "UPDATE" privillages to a user DEBUG. but when i call :
> ResultSet ts = dbmd.getTablePrivileges("pg_catalog","public","PRIV_TEST");
>
> Many rows are returned including the two privillages i granted, plust
> some indicating PRIVILLAGE=UNKNOWN
>
> Is this a bug in the JDBC driver or i am missing something??
>

This is indeed a bug in the driver. As listed on the todo, the ACL
parsing code has not been updated since the 7.3 release and does not work
correctly against later servers.

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2006-02-01 18:59:36 Re: Prepared Statement is not parsed correctly
Previous Message Markus Schaber 2006-02-01 17:15:25 Re: timestamp parameter is null