Re: Multiple Servers

Sorry for the interruption into this discussion, but it
is very similar to the question I posted two weeks ago
(http://fts.postgresql.org/db/mw/msg.html?mid=1027722).

I have since revised my ideas of how my databases should
be set up, ie:

    * Users need to have superuser access to their OWN
      databases
    * Users should not have the ability to create users
      or databases
    * Users _need_ to be able to create tables, modify
      tables, drop tables, etc

I hope that I don't need to run multiple postmasters to get
this done, as the DB machine is .. well .. needing some hardware
upgrades.

My own [twisted, non-programmer] logic tells me that I should
be able to create a database, add a user, and grant all on
<database> for that specific user.  But, my SQL abilities are
almost nil, and when I try to grant such things on a database,
it denies me (No, I don't recall the error.  Yes, I will
duplicate it and provide the _exact_ error).  :/

Specifics:  PostgreSQL 7.1.2, OpenBSD 2.9 (DB), OpenBSD 2.8 on
the client side.

If anyone can give me some hints on how to do this, I would be
VERY appreciative.

Benny


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
You see, we're leveraging the synergies of our existing open source
solution, without reliance on a single vendor.
Or in english: We use samba cause NT sucks ass.
                                                       --greg@rage.net