Additional Grants To SuperUser?

From: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Additional Grants To SuperUser?
Date: 2011-02-04 18:27:49
Message-ID: AANLkTinN4ZNoQcjxX5qxOZoZTEeAVA6yveSAgEKRiXGH@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I created a role named 'carlos' which is my current user account with
'superuser' grants but my question is when I look at 'postgres'
account, he has additional grants that I don't understand.

List of roles
Role name | Attributes | Member of
-----------+-------------+-----------
carlos | Superuser | {}
jmadeline | Create DB | {}
mwilshaw | Create DB | {}
postgres | Superuser | {}
: Create role
: Create DB

So from what I see above, 'carlos' is a superuser but do I need to
grant him 'CREATEROLE' & 'CREATEDB' rights along with 'SUPERUSER' or
is 'SUPERUSER' by itself good enough?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jon Nelson 2011-02-04 18:45:47 varchar (no 'N') vs. text
Previous Message Yeb Havinga 2011-02-04 18:08:40 Re: set theory question