Thread

1. Account in postgresql database

   Yann Michel <yann-postgresql@spline.de> — 2005-06-08T20:40:28Z

   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.
   
   Regards,
   Yann
   
   ---------------------------------------------------------------------
                 Human knowledge belongs to the world.
                 The answer is open source !
   ---------------------------------------------------------------------
   
   

2. Re: Account in postgresql database

   Hannu Krosing <hannu@tm.ee> — 2005-06-08T22:03:42Z

   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>
   
   

3. Re: Account in postgresql database

   Josh Berkus <josh@agliodbs.com> — 2005-06-09T04:12:44Z

   Yann,
   
   > 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.
   
   That's on the TODO list.  As far as I know, nobody is currently working on it.
   
   -- 
   Josh Berkus
   Aglio Database Solutions
   San Francisco
   
   

4. Re: Account in postgresql database

   Yann Michel <yann-postgresql@spline.de> — 2005-06-09T10:15:07Z

   Hi Hannu,
   
   On Thu, Jun 09, 2005 at 01:03:42AM +0300, Hannu Krosing wrote:
   > > 
   > > 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
   
   Yes, that is quite the thing, I was looking for. But unfortunately there
   is a note within the documentation: "Note: This feature is intended as a
   temporary measure until a complete solution is found. At that time, this
   option will be removed."
   
   Another question is, how to grant the right of creating a databaseuser
   to a certain database user for only one database.
   
   Regards,
   Yann