Re: Need some help creating a database sandbox... - Mailing list pgsql-general

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