Lists: | pgsql-jdbc |
---|
From: | Altaf Malik <mmalik_altaf(at)yahoo(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | getTablePrivillages giving wrong privillages |
Date: | 2006-02-01 14:13:22 |
Message-ID: | 20060201141322.15994.qmail@web30211.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
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
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 |
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