If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Creating a DBA Superuser Group Role

I created a role called 'dba':

Code:

CREATE ROLE dba NOLOGIN SUPERUSER CREATEDB CREATEROLE REPLICATION;

Then I add my role 'carlos' to the 'dba' role:

Code:

GRANT dba TO carlos;

So doesn't that mean that 'carlos' is now a superuser? When I logged in as carlos and tried to do something in pgAdmin, I got an error saying I wasn't a superuser. Am I missing something? Not sure if my user role 'carlos' or group role 'dba' is missing some kind of INHERIT which would make all roles granted to 'dba' a superuser.