superuser equality

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: "Pgsql General" <pgsql-general(at)postgresql(dot)org>
Subject: superuser equality
Date: 2004-11-06 16:42:20
Message-ID: 200411060942.20646.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Net Virtual Mailing Lists 2004-11-06 16:48:10 Temporarily disable rule, is this possible?
Previous Message Ed L. 2004-11-06 16:30:30 Re: Can this be indexed?