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