Re: getTablePrivillages giving wrong privillages - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: getTablePrivillages giving wrong privillages
Date
Msg-id Pine.BSO.4.61.0602011222240.4903@leary.csoft.net
Whole thread Raw
In response to getTablePrivillages giving wrong privillages  (Altaf Malik <mmalik_altaf@yahoo.com>)
List 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

pgsql-jdbc by date:

Previous
From: "Senden Kris"
Date:
Subject: Prepared Statement is not parsed correctly
Next
From: Kris Jurka
Date:
Subject: Re: Prepared Statement is not parsed correctly