Hi,
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","PRI V_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??

Thanks,
Altaf Malik


---------------------------------

What are the most popular cars? Find out at Yahoo! Autos

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","PRI V_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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly