Re: New to postgresql - Do I have to be a "superuser" to be able to create a database?

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: New to postgresql - Do I have to be a "superuser" to be able to create a database?
Дата
Msg-id CAMkU=1zE9oDv9pLUn596xFKpRX4gOnv+xPNopDVJ9yCVZryA-Q@mail.gmail.com
обсуждение исходный текст
Ответ на New to postgresql - Do I have to be a "superuser" to be able to create a database?  (gromitracer <george_m_se@yahoo.com>)
Список pgsql-general

On Sun, Jan 5, 2014 at 7:32 PM, gromitracer <george_m_se@yahoo.com> wrote:
Hello all. I am more accustomed in doing things the Oracle way and I am
trying to get a hold postgres :)

Below are my roles/users and their attributes.  Posgresql version: 9.2

   Role name     |            Attributes
| Member of
---------------+-------------------------------------------------------------------------------+----------------
 devs                | Create DB, Cannot login
|   {}
 batman            |
|   {devs}
 postgres          | Superuser, Create role, Create DB, Replication   |
{}


As you can see:
role:  DEVS is configured to be able to create a database.
user: batman is member of DEVS

CreateDB is not inherited.  It must be granted directly to the role that will use it.


Cheers,

Jeff

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

Предыдущее
От: AI Rumman
Дата:
Сообщение: EMC SRDF technology for creating replication with Postgresql?
Следующее
От: Vincent Veyron
Дата:
Сообщение: Re: New to postgresql - Do I have to be a "superuser" to be able to create a database?