Inherit Superuser Role Help

From: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Inherit Superuser Role Help
Date: 2013-04-18 03:06:18
Message-ID: CAAQLLO5ZMj_g5o+Xby_99S0p8+nD1rmvk8+WvPRATBxTOxAe7g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

What am I missing here?

postgres=> SELECT current_user;
current_user
--------------
carlos
(1 row)

postgres=> CREATE DATABASE carlosdb;
ERROR: permission denied to create database

postgres=> \du
List of roles
Role name | Attributes
| Member of
-----------+--------------------------------------------------------------+-----------
carlos |
| {dba}
chris |
| {web}
dba | Superuser, Create role, Create DB, Cannot login, Replication | {}
postgres | Superuser, Create role, Create DB, Replication | {}
web | Cannot login | {}

Shouldn't 'carlos' be a superuser based on him being a member of a
role which has createdb and superuser rights granted to it?

--
Carlos Mennens

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-04-18 03:16:31 Re: Inherit Superuser Role Help
Previous Message Tom Lane 2013-04-17 22:17:33 Re: [GENERAL] currval and DISCARD ALL