On Aug 2, 2005, at 11:33 PM, Tom Lane wrote:
> "Eric D. Nielsen" <nielsene@mit.edu> 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