From: | Chris Cameron <chris(at)upnix(dot)com> |
---|---|
To: | "C(dot) Bensend" <benny(at)bennyvision(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Multiple Servers |
Date: | 2001-08-21 03:09:07 |
Message-ID: | 5.1.0.14.0.20010820210330.0358e410@mail.upnix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Alright,
Seems the general problem is that people (me and "Benny") want to do what
can be done with MySQL and be able to add a user, give them their own DB to
play with, and leave it at that. However, Postgres doesn't seem to have as
slick of a way to do such a thing because to let a user have control over
their own database, they would have had to of been able to create the DB.
And if they were able to create the DB, they'd be able to make others.
I managed to do this (albeit not very gracefully). I created the user
'test' and game him permission to create DB's. Made a database with his
username, then took away his ability to create databases. This allowed him
to fool with his own DB (because he created it), but he could no longer
create new DB's.
Still, this seems like a bit of a crummy way to accomplish such a thing. I
haven't been around PostgreSQL long enough to know how development takes
place, but this is a decent feature to have in a DB I figure.
Thanks for all your suggestions,
Chris
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-08-21 03:56:56 | Re: Multiple Servers |
Previous Message | C. Bensend | 2001-08-21 02:39:01 | Re: Multiple Servers |