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

Strange result from DatabaseMetaData.getTablePrivileges()

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Strange result from DatabaseMetaData.getTablePrivileges()
Date: 2007-01-28 17:26:19
Message-ID: epimbr$6nn$1@sea.gmane.org (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hello,

I just noticed that getTablePrivileges() returns the same privilege for the same 
user multiple times. Additionally it returns several rows with the privilege 
"UNKNOWN".

Is this a bug, or am I simply misunderstanding something?

The following test code:

Class.forName("org.postgresql.Driver");
con = DriverManager.getConnection("jdbc:postgresql://localhost/wbtest", 
"thomas", "****");
con.setAutoCommit(true);
stmt = con.createStatement();

stmt.executeUpdate("create table test_table (nr integer)");
stmt.executeUpdate("grant select,insert,update on test_table to postgres");
rs = con.getMetaData().getTablePrivileges(null, "public", "test_table");
while (rs.next())
{
   System.out.print("table_name: " + rs.getString("TABLE_NAME"));
   System.out.print(", grantor: " + rs.getString("GRANTOR"));
   System.out.print(", grantee: " + rs.getString("GRANTEE"));
   System.out.println(", privilege: " + rs.getString("PRIVILEGE"));
}
stmt.executeUpdate("drop table test_table");

produces the following ouput:

table_name: test_table, grantor: thomas, grantee: thomas, privilege: DELETE
table_name: test_table, grantor: thomas, grantee: thomas, privilege: INSERT
table_name: test_table, grantor: thomas, grantee: thomas, privilege: INSERT
table_name: test_table, grantor: thomas, grantee: postgres, privilege: INSERT
table_name: test_table, grantor: thomas, grantee: postgres, privilege: INSERT
table_name: test_table, grantor: thomas, grantee: thomas, privilege: REFERENCES
table_name: test_table, grantor: thomas, grantee: thomas, privilege: SELECT
table_name: test_table, grantor: thomas, grantee: postgres, privilege: SELECT
table_name: test_table, grantor: thomas, grantee: thomas, privilege: TRIGGER
table_name: test_table, grantor: thomas, grantee: thomas, privilege: TRIGGER
table_name: test_table, grantor: thomas, grantee: postgres, privilege: TRIGGER
table_name: test_table, grantor: thomas, grantee: thomas, privilege: UNKNOWN
table_name: test_table, grantor: thomas, grantee: thomas, privilege: UNKNOWN
table_name: test_table, grantor: thomas, grantee: thomas, privilege: UNKNOWN
table_name: test_table, grantor: thomas, grantee: thomas, privilege: UNKNOWN
table_name: test_table, grantor: thomas, grantee: thomas, privilege: UNKNOWN
table_name: test_table, grantor: thomas, grantee: postgres, privilege: UNKNOWN
table_name: test_table, grantor: thomas, grantee: postgres, privilege: UNKNOWN
table_name: test_table, grantor: thomas, grantee: postgres, privilege: UNKNOWN
table_name: test_table, grantor: thomas, grantee: postgres, privilege: UNKNOWN
table_name: test_table, grantor: thomas, grantee: postgres, privilege: UNKNOWN
table_name: test_table, grantor: thomas, grantee: thomas, privilege: UPDATE
table_name: test_table, grantor: thomas, grantee: postgres, privilege: UPDATE

Note that e.g. the INSERT privilege for the user postgres is returned twice, 
whereas the SELECT privilege for the user postgres is only returned once (which 
is what I would have expected)

And what are all the UNKNOWN entries?

This is with build 504 of the JDBC Driver running on Windows XP against a 
Postgres 8.2.1 installed on the same machine using JDK 1.5.

Thomas


Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2007-01-28 22:36:39
Subject: Re: Strange result from DatabaseMetaData.getTablePrivileges()
Previous:From: Ken JohansonDate: 2007-01-28 15:51:17
Subject: Re: Synthesize support for Statement.getGeneratedKeys()?

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