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 <[EMAIL PROTECTED]>'
Key retrival: Send an E-Mail to [EMAIL PROTECTED]
E-Mail: [EMAIL PROTECTED] Web: http://www.scode.org


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to