Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group