On Aug 2, 2005, at 11:33 PM, Tom Lane wrote:
"Eric D. Nielsen" <nielsene@xxxxxxx> writes:
... simplest way I thought would be to have the testing tools drop/
create
the testing database on every test case, and then populate the
database from a specified file. However I don't want to give the
test user superuser privileges. Thus I don't think I can restrict it
to only drop/create a single named DB.
CREATEDB is a pretty restricted privilege --- I don't actually see
the problem here?
regards, tom lane
I was equating CREATEDB as superuser. Its not I see. So if a user
has CREATEDB, but not CREATEUSER, I should be safe.
Thanks!
Eric
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
