On Fri, Sep 23, 2005 at 01:13:37 +0200, Wim Bertels <wim.bertels@xxxxxxxxxxx> wrote: > 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! Tell people not to do this. Use ident authentication. Give each person their own postgres account. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
