Skip site navigation (1) Skip section navigation (2)

Re: Preventing changes to default settings of a collective account?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alex Gutman <agutman(at)emc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Preventing changes to default settings of a collective account?
Date: 2005-02-24 15:45:34
Message-ID: 25157.1109259934@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Alex Gutman <agutman(at)emc(dot)com> writes:
> (The NOCREATEUSER option used when creating the collective user does
> prevent it from changing its own password via
> ALTER USER guest WITH ... PASSWORD ...

You think so?

This approach is doomed to failure --- the system sees no reason not to
allow a user to change his own configuration, including his password.

> Is there any way I could achieve my goal?

Use more than one username.

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Joel FradkinDate: 2005-02-24 16:10:41
Subject: Re: invalid multibyte character for locale
Previous:From: Scott MarloweDate: 2005-02-24 15:43:23
Subject: Re: CVS Database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group