Postgres Pro
Downloads
Home   >   mailing lists

a problem with getting correct info about table's privileges - Mailing list pgsql-jdbc

From Andy Burgard
Subject a problem with getting correct info about table's privileges
Date
Msg-id AANLkTinvnCiL4L7rucFkbBahoLMjQqvUhRMUmfXksVmy@mail.gmail.com
Whole thread Raw
Responses Re: a problem with getting correct info about table's privileges  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Tree view
Hello everybody,

I have a problem with getting correct info about table's privileges. I have a table with a SELECT privilege granted to "not_owner" user by the table's owner. However when I connect to the database as "not_owner" and ask for the privileges (using java.sql.DatabaseMetaData.getTablePrivileges()) on this table granted to "not_owner" I get DELETE, SELECT, and TRIGGER.

Does anybody have an idea what is going on?

My environment: Windows Server 2003 R2, PostgreSQL 8.3, JDK 1.6.07, postgresql-8.4-701.jdbc4.jar

Thanks for the help,

Andy 

pgsql-jdbc by date:

Previous
From: John R Pierce
Date:
Subject: Re: jdbc works in java app, fails in servlet: "no suitable jdbc found"
Next
From: Manohar Bhattarai
Date:
Subject: Re: Not able to connect to postgresql database