X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B5ADBD6F4F for ; Thu, 22 Sep 2005 20:53:06 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 52954-06 for ; Thu, 22 Sep 2005 23:53:02 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 6D1ADD6F38 for ; Thu, 22 Sep 2005 20:53:03 -0300 (ADT) X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5BFD0.C6A60ABE" Subject: Re: alter user Date: Thu, 22 Sep 2005 18:51:35 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] alter user Thread-Index: AcW/zYpujlWzSU0FRqSTTXVUwCh2VAAAwZq+ From: "Scott Marlowe" To: , X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.035 required=5 tests=[AWL=-0.022, HTML_30_40=0.056, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200509/245 X-Sequence-Number: 18982 This is a multi-part message in MIME format. ------_=_NextPart_001_01C5BFD0.C6A60ABE Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Instead of using a general purpose account, why not give everyone an = account, then make them a member of a group, and give that group the = access. That way you can easily add / remove people from the group instead of = trying to do it this way. Otherwise, don't use a password, set the machine to use trust or ident = or something like that where a password wouldn't matter. -----Original Message----- From: pgsql-admin-owner@postgresql.org on behalf of Wim Bertels Sent: Thu 9/22/2005 6:13 PM To: pgsql-admin@postgresql.org Subject: [ADMIN] alter user =20 Ls, any user can change his own password, i haven't found a way of prohibiting this. what about a general user (eg test/test), that is used by many people, one of those people could use alter user (being connected as test/test) = the=20 change the password, leaving the rest clueless.. suggestions to prevent this?, i need a general (readonly) user! --=20 Wim Bertels ------_=_NextPart_001_01C5BFD0.C6A60ABE Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: [ADMIN] alter user

Instead of using a general purpose account, why not = give everyone an account, then make them a member of a group, and give = that group the access.

That way you can easily add / remove people from the group instead of = trying to do it this way.

Otherwise, don't use a password, set the machine to use trust or ident = or something like that where a password wouldn't matter.

-----Original Message-----
From: pgsql-admin-owner@postgresql.org on behalf of Wim Bertels
Sent: Thu 9/22/2005 6:13 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] alter user

Ls,

any user can change his own password,
i haven't found a way of prohibiting this.
what about a general user (eg test/test), that is used by many = people,
one of those people could use alter user (being connected as test/test) = the
change the password, leaving the rest clueless..

suggestions to prevent this?, i need a general (readonly) user!

--
Wim Bertels


------_=_NextPart_001_01C5BFD0.C6A60ABE--