| 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: | Whole Thread | Raw Message | 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 |