jason@netspade.com writes:
> Okay here's a context diff against CVS for getting table privileges. I may have more code to add (I noticed
getColumnPrivileges()is not completed - could use my routine for parsing pg_class.relacl?).
The list of columns you return is wrong. There is no COLUMN_NAME column.
TABLE_CAT should be filled in with the database name (should be available
via getConnection().getCatalog()). A missing TABLE_SCHEM should be set to
null (in the SQL sense). Also you have GRANTOR and GRANTEE mixed up,
besides the fact that PostgreSQL doesn't store the GRANTEE at all (yet).
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter