Follow-up OpenOffice and Postgres 7.3.2

From: Adrian Klaver <aklaver(at)attbi(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Follow-up OpenOffice and Postgres 7.3.2
Date: 2003-03-19 03:59:36
Message-ID: 200303181959.36621.aklaver@attbi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I finally tracked down the problem. You have to use the GRANT command to set
privileges on your table. Postgres assumes the table owner has all rights but
does do not write that info into the access control list of pg_class. It
would seem the JDBC driver looks to pg_class for information on permissions.
Using GRANT makes the permissions explicit and therefore makes the JDBC
driver happy.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2003-03-19 04:03:47 Re: Sun J2SE 1.4 + postgresql-jdbc3-7.3.jar + Postgresql 7.2.1
Previous Message Barry Lind 2003-03-19 01:45:10 Re: Temporary memory peak