Re: Creating a DB for another user (or...) (repost attempt)

Поиск
Список
Период
Сортировка
От Matthew Rice
Тема Re: Creating a DB for another user (or...) (repost attempt)
Дата
Msg-id 200008251818.OAA00994@hudson.starnix.com
обсуждение исходный текст
Ответ на Creating a DB for another user (or...) (repost attempt)  (Matthew Rice <matt@starnix.com>)
Ответы Re: Creating a DB for another user (or...) (repost attempt)  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
Список pgsql-general
> > Is there a way to either assign superuser priviledges/ownership
> > to that user or to create the database for him?
>
> alter user "name" createdb;

Are you certain?  From the 6.5 docs it says that this will:

    Give a user the ability to create new databases

Are you saying that I temporarily let the user create dbs, create the
db and the remove the ability to create dbs?

BTW, this isn't a system user so how would he run createdb?

Regards,
--
matthew rice <matt@starnix.com>                               starnix inc.
tollfree: 1-87-pro-linux                        thornhill, ontario, canada
http://www.starnix.com              professional linux services & products

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

Предыдущее
От: "Mike Sears"
Дата:
Сообщение: system catalog problems
Следующее
От: "Martin A. Marques"
Дата:
Сообщение: Re: alter table and constraints