| From: | Murray Cumming <murrayc(at)murrayc(dot)com> |
|---|---|
| To: | Michael Fuhr <mike(at)fuhr(dot)org> |
| Cc: | pgsql-interfaces <pgsql-interfaces(at)postgresql(dot)org> |
| Subject: | Re: per-database groups? (was Discovering privileges) |
| Date: | 2005-03-21 21:17:12 |
| Message-ID: | 1111439833.5554.61.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
On Mon, 2005-03-21 at 14:13 -0700, Michael Fuhr wrote:
> On Mon, Mar 21, 2005 at 07:38:00PM +0100, Murray Cumming wrote:
>
> > I notice that users and groups are per-cluster rather than per-database.
> > Is there any way to create users and groups that are not available to
> > other databases on the same cluster?
>
> What do you mean by "available"? You can use pg_hba.conf to control
> which users can connect to which databases, if that's what you're
> after. Or maybe db_user_namespace will do what you want:
>
> http://www.postgresql.org/docs/8.0/interactive/runtime-config.html#GUC-DB-USER-NAMESPACE
Thanks. That looks like what I want.
--
Murray Cumming
murrayc(at)murrayc(dot)com
www.murrayc.com
www.openismus.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kathy Smith | 2005-03-23 19:35:12 | Execute access on functions |
| Previous Message | Michael Fuhr | 2005-03-21 21:13:39 | Re: per-database groups? (was Discovering privileges) |