Re: [HACKERS] Account in postgresql database
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 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] Account in postgresql database
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 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[HACKERS] Account in postgresql database
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 ! - ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Account in postgresql database
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 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster