Re: Follow-up OpenOffice and Postgres 7.3.2

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