Skip site navigation (1) Skip section navigation (2)

Re: creating users per database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: creating users per database
Date: 2006-01-28 16:04:09
Message-ID: 11901.1138464249@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> writes:
> I have a faint memory of it being possible to create users
> "inside" *one* given database by way of a particular "create
> user" syntax along the lines of:

>  create user newuser(at)thisdb ...;

There is the db_user_namespace kluge^H^H^H^H^Hparameter, but it's
pretty ugly.  Do you really need DB-specific user names, or just
a more convenient way to limit which DBs a user can connect to?  If
the latter, the "samegroup" technique Philippe mentions seems like
a good bet.

			regards, tom lane

In response to

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2006-01-28 16:13:36
Subject: Re: stats for failed transactions (was Re: [GENERAL] VACUUM Question)
Previous:From: Matthew T. O'ConnorDate: 2006-01-28 15:53:54
Subject: Re: stats for failed transactions (was Re: [GENERAL] VACUUM

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group