| From: | "Eric D(dot) Nielsen" <nielsene(at)MIT(dot)EDU> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Eric D(dot) Nielsen" <nielsene(at)mit(dot)edu>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Need some help creating a database sandbox... |
| Date: | 2005-08-03 03:39:55 |
| Message-ID: | 26A2169C-8C10-4CDC-A0E2-F86D03CE42CE@mit.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Aug 2, 2005, at 11:33 PM, Tom Lane wrote:
> "Eric D. Nielsen" <nielsene(at)mit(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oluwatope Akinniyi | 2005-08-03 05:57:47 | Re: Insert ImageFile in PostgreSQL |
| Previous Message | chiranjeevi.i | 2005-08-03 03:38:48 | How to write jobs in postgresql |