| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "John R Pierce *EXTERN*" <pierce(at)hogranch(dot)com>, "Schwaighofer Clemens" <clemens(dot)schwaighofer(at)tequila(dot)jp> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Strange Grant behavior in postgres 8.3 |
| Date: | 2009-02-18 08:39:35 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C20313E100@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
John R Pierce wrote:
> that is correct. DATABASE privileges relate to connecting to the
> database, permissions to create objects and so forth.
To be precise, there are 3 privileges:
- create temporary tables
- connect to the database
- create schemata
To be allowed to create a table, you need the create privilege
on the containing schema.
To be allowed to select from a table, you also need the usage
privilege on the schema containing the object.
You have all privileges on an object you own.
I guess that should clarify the behaviour in the original question.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-02-18 08:42:17 | Re: Strange Grant behavior in postgres 8.3 |
| Previous Message | Schwaighofer Clemens | 2009-02-18 07:26:27 | Re: Strange Grant behavior in postgres 8.3 |