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

From Dave Cramer
Subject Re: Follow-up OpenOffice and Postgres 7.3.2
Date
Msg-id 1048066560.18393.119.camel@inspiron.cramers
Whole thread Raw
In response to Re: Follow-up OpenOffice and Postgres 7.3.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Follow-up OpenOffice and Postgres 7.3.2
List pgsql-jdbc
The driver doesn't do anything when a "create table foo ..." is
executed, and there is no api for modifying the user permissions ??

Dave
On Wed, 2003-03-19 at 00:53, Tom Lane wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Dave Cramer <Dave@micro-automation.net>


pgsql-jdbc by date:

Previous
From: Davide Romanini
Date:
Subject: JDBC driver, PGSQL 7.3.2 and accents characters
Next
From: Dave Cramer
Date:
Subject: Re: auto generated keys