Thread: Postgres user lost its access

Postgres user lost its access

From
Peter Schuller
Date:
Hello,

suddenly I find that the postgres user no longer has permission to
create new users and databases.

What do I do? :) I haven't fiddled with it at all AFAIK, so I can't
imagine what triggered the problem.

I'm *about* to fiddle though. Any hints on making PostgreSQL secure in a
multi-user environment? I've read stuff about code running inside
PostgreSQL by default; and I've had it allow an arbitrary local user
create and drop databases. Is there an easy way to shut EVERYONE
except the postgres user out of EVERYTHING so that I can selectively
allow what I want to allow?

(And I promise, I wasn't experimenting with the latter when causing the
former :)).

--
/ Peter Schuller, InfiDyne Technologies HB

PGP userID: 0xE9758B7D or 'Peter Schuller <peter.schuller@infidyne.com>'
Key retrival: Send an E-Mail to getpgpkey@scode.org
E-Mail: peter.schuller@infidyne.com Web: http://www.scode.org