[GENERAL] superuser equality

2004-11-06 Thread Ed L.
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

Re: [GENERAL] superuser equality

2004-11-06 Thread Peter Eisentraut
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