Thread: getTablePrivillages giving wrong privillages
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","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??
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","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