confused by superuser-definition

From: "zuhans(at)iname(dot)com" <zuhans(at)iname(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: confused by superuser-definition
Date: 2004-05-31 08:36:56
Message-ID: 40BAEEA8.2050603@iname.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hello,

i'm rather new to postgresql and am now standing in front of a big problem.

if i want to host my database on any provider out there, i don't now see
any chance to get my own right to insert new users into my db. because:
i'd only be able to do this, when i had the rights to "createuser", but
that would mean, that i'd have the superuser-rights for the whole db's
in "public" - if there is only this base-schema.

do i understand this right?

if yes: what is a common approach to manage just own users if there is
the situation, that i have a changing amount of them?

btw: why isn't it possible to have (in a future release) a
createuser-right just for single databases and to have one
root/super-user for everydb?

greetings from today very sunny autria
hans

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben-Nes Michael 2004-05-31 10:49:51 pg_dump and errors
Previous Message Ago 2004-05-31 08:17:44 Separating application from data