Re: Account in postgresql database
Hannu Krosing <hannu@tm.ee>
From: Hannu Krosing <hannu@tm.ee>
To: Yann Michel <yann-postgresql@spline.de>
Cc: PostgreSQL-Hackers <pgsql-hackers@postgresql.org>
Date: 2005-06-08T22:03:42Z
Lists: pgsql-hackers
On K, 2005-06-08 at 22:40 +0200, Yann Michel wrote: > Hi, > > I was searching for some information about the storage of the user data > in postgresql. As far as I know there is one dictionary table for > storeing all the users of any known database, right? > > As we'd like to provide a postgresql database service to our students > we'd like to create one database for each user. This user should be able > to create new accounts for other users but only for his/her database. > > Any comments or solutions are welcome. see if db_user_namespace (in postgresql.conf) can solve your problem -- Hannu Krosing <hannu@tm.ee>