dropdb ; createdb equivalent without createdb permission?

Поиск
Список
Период
Сортировка
От Tim Olsen
Тема dropdb ; createdb equivalent without createdb permission?
Дата
Msg-id 4be80d840707091113h1392a130s2c32689ff916b60c@mail.gmail.com
обсуждение исходный текст
Ответы Re: dropdb ; createdb equivalent without createdb permission?  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: dropdb ; createdb equivalent without createdb permission?  (Steve Crawford <scrawford@pinpointresearch.com>)
Список pgsql-general
Hello,

I would like to be able to grant a user the ability to completely
reset a database for testing purposes.  If possible, I would like the
user to be able to do a "dropdb" followed by a "createdb", but without
allowing this user to create any database.  In other words, I would
like the user to be granted createdb permission for only a particular
database.  I don't believe this is possible in postgresql.  Is there a
dropdb-followed-by-createdb equivalent the user could use?

Thanks,
Tim

В списке pgsql-general по дате отправления:

Предыдущее
От: Raymond O'Donnell
Дата:
Сообщение: Re: Windows Vista not working
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: dropdb ; createdb equivalent without createdb permission?