superuser equality

Started by Ed L.over 21 years ago2 messagesgeneral
Jump to latest
#1Ed L.
pgsql@bluepolka.net

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

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Ed L. (#1)
Re: superuser equality

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/