Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Janes
Subject Re: New to postgresql - Do I have to be a "superuser" to be able to create a database?
Date
Msg-id CAMkU=1zE9oDv9pLUn596xFKpRX4gOnv+xPNopDVJ9yCVZryA-Q@mail.gmail.com
Whole thread Raw
In response to New to postgresql - Do I have to be a "superuser" to be able to create a database?  (gromitracer <george_m_se@yahoo.com>)
List pgsql-general
Tree view

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 by date:

Previous
From: AI Rumman
Date:
Subject: EMC SRDF technology for creating replication with Postgresql?
Next
From: Vincent Veyron
Date:
Subject: Re: New to postgresql - Do I have to be a "superuser" to be able to create a database?