On Sun, Jan 5, 2014 at 7:32 PM, gromitracer <george_m_se@xxxxxxxxx> 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
