Postgres user lost its access - Mailing list pgsql-admin

From Peter Schuller
Subject Postgres user lost its access
Date
Msg-id 20020313222041.GL1344@prometheus
Whole thread Raw
List pgsql-admin
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


pgsql-admin by date:

Previous
From: "James Kelty"
Date:
Subject: Order by clause in 'select distinct'?
Next
From: Tom Lane
Date:
Subject: Re: Postgre 7.1.3 and Solaris Install Problems