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