From: | Simone Tellini <tellini(at)areabusiness(dot)it> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Multiple Servers |
Date: | 2001-08-21 13:41:53 |
Message-ID: | 20010821154141.6395.TELLINI@areabusiness.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Tue, 21 Aug 2001 07:05:41 -0500 (CDT)
"C. Bensend" <benny(at)bennyvision(dot)com> wrote:
CB> > So, create a database for the user as the user, but deny him the ability to
CB> > create databases or users.
[...]
CB> This is what I ended up doing for a solution.
CB> Yes, very workable. It was just a few more steps than
I've found out a small problem with this procedure: you won't be able to
restore the data after a dumpall, unless you manually edit the dump
first to add CREATEDB to the CREATEUSER commands and then manually
remove the permissions after the restore.
Hopefully one shouldn't need to restore everything so often.
--
Simone Tellini
E-mail: tellini(at)areabusiness(dot)it
http://www.areabusiness.it
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-08-21 16:12:48 | RE: Creating Users |
Previous Message | Tom Lane | 2001-08-21 13:35:41 | Re: Multiple Servers |