Re: Follow-up OpenOffice and Postgres 7.3.2 - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Follow-up OpenOffice and Postgres 7.3.2
Date
Msg-id 4379.1048053222@sss.pgh.pa.us
Whole thread Raw
In response to Follow-up OpenOffice and Postgres 7.3.2  (Adrian Klaver <aklaver@attbi.com>)
Responses Re: Follow-up OpenOffice and Postgres 7.3.2
List pgsql-jdbc
Adrian Klaver <aklaver@attbi.com> writes:
> 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.

Hm.  The backend treats NULL in pg_class.relacl as meaning the default
permissions (owner = all, everyone else = none).  I wonder whether jdbc
gets that right?

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: WARNING on setAutoCommit
Next
From: "Paul Sorenson"
Date:
Subject: auto generated keys