Re: Table Permission? - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Table Permission?
Date
Msg-id 20050712152420.GA4891@wolff.to
Whole thread Raw
In response to Table Permission?  (Søren Poulsen <wmsopou@hotmail.com>)
List pgsql-novice
On Sun, Jul 10, 2005 at 22:39:33 +0200,
  Søren Poulsen <wmsopou@hotmail.com> wrote:
> Im denied permission to select from a table that im the owner of, in a
> schema that own too. Only if I grant access to public on both am I permitted
> to select - shouldnt I have have usage permission as owner? Btw. im logging
> in using jdbc.

The only of a table doesn't necessarily have select access to it. However,
you would have that access after creating the table unless you explicitly
revoked it. A similar situation applies to usage access to the schema.

pgsql-novice by date:

Previous
From: "Evans, Roy"
Date:
Subject: ERROR: plperl functions cannot take type anyarray
Next
From: Tom Lane
Date:
Subject: Re: ERROR: plperl functions cannot take type anyarray