Fw: Help on user creation with password enable...

Anyone can give me some idea how to solve the problem...

----------  Forwarded message ----------
Date: Wed, 25 Jul 2001 14:14:38 +0800
From: Ang Sei Heng <seiheng@talariax.com>
To: pgsql-admin@postgresql.org
Subject: Help on user creation with password enable...

> Hello,
>
> I have trying to create user (with password access) to one of the
> database. Basically the user will be able to create it's own
> database but unable to add other user.
>
> However, the password does not seems to be working. I did the
> following:
>
> %> createuser -W -U testuser
>
> The message from the command seems to be ok. It prompt me for
> the password. But when I try to create database via this
> use, it does not prompt for password. Infact, I can even
> access any database via this user. Even worst! I can simply
> create/delete any tables from any database.
>
> I wonder did I do something wrong? I am sure that PostgreSQL 7.1.2
> should not give me such a bug right??
>
> Any one out there can help me?? Am suppose to enable something
> while compile PostgreSQL? I cannot let my user to access the
> database system until this is solve.
>
> Thanks,
> Sei Heng
>
> /* ------------------------------------------------------
>
> I rather be free in Hell, then a slave in Heaven
>
> ------------------------------------------------------ */