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
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 |