| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Søren Poulsen <wmsopou(at)hotmail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Table Permission? |
| Date: | 2005-07-12 15:24:20 |
| Message-ID: | 20050712152420.GA4891@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Sun, Jul 10, 2005 at 22:39:33 +0200,
Søren Poulsen <wmsopou(at)hotmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-07-12 15:28:58 | Re: ERROR: plperl functions cannot take type anyarray |
| Previous Message | Evans, Roy | 2005-07-12 15:06:28 | ERROR: plperl functions cannot take type anyarray |