Thread: superuser equality

I'd like to have a DB client connect using a username ('psuedodba')
different from the creator/owner ('dba') of the DB and its tables, but
still have that username be able to do everything the creator/owner can do
(alter tables, drop databases, etc).  It appears that

    "createuser -d -a psuedodba"

works for this purpose.  Are there circumstances where 'psuedodba' lacks
powers that 'dba' has to create/destroy/alter/update/insert/delete?  Or are
they truly equivalent in powers?

TIA.

Ed

Ed L. wrote:
>     "createuser -d -a psuedodba"
>
> works for this purpose.  Are there circumstances where 'psuedodba'
> lacks powers that 'dba' has to
> create/destroy/alter/update/insert/delete?  Or are they truly
> equivalent in powers?

You have created a superuser, who can do anything.  This may be even
more than the "dba" user.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/