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

Le dimanche 05 janvier 2014 à 19:32 -0800, gromitracer a écrit :

> 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
>
> However, when I login as batman and I issue the command "CREATE DATABASE
> metropolis;" I get a Permission denied. Even when I give DEVS a "superuser"
> attribute, user batman still cannot create a database. Do I have to elevate
> user batman to a superuser? Isn't that dangerous when it comes to security?
>

No need to be a superuser; see the CREATEDB clause in :

http://www.postgresql.org/docs/9.3/static/sql-createrole.html

You probably will also need to study :

http://www.postgresql.org/docs/9.3/static/sql-grant.html

--
http://litigios.libremen.com
Gestión de litigios y de expedientes de seguros de siniestros para el
servicio jurídico