a problem with getting correct info about table's privileges

From: Andy Burgard <andy(dot)burgard(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: a problem with getting correct info about table's privileges
Date: 2010-06-04 19:37:14
Message-ID: AANLkTinvnCiL4L7rucFkbBahoLMjQqvUhRMUmfXksVmy@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message philfrei 2010-06-05 07:11:38 Re: jdbc works in java app, fails in servlet: "no suitable jdbc found"
Previous Message John R Pierce 2010-06-04 06:40:36 Re: jdbc works in java app, fails in servlet: "no suitable jdbc found"