Thread: a problem with getting correct info about table's privileges

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 

On Fri, 4 Jun 2010, Andy Burgard wrote:

> 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?

It's not clear exactly what you are doing and expecting.  It sounds a
little like you are expecting getTablePrivileges to return just the
privileges for the current user, but it will return the privileges for all
users.

What do you get from the following?

SELECT relacl from pg_class WHERE relname = 'mytablename'

Kris Jurka