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

Hi,

Check permissions in pg_hba.conf file: $PGDATA/pg_hba.conf.

Ricardo Maia

On Wednesday 25 July 2001 10:23, Ang Sei Heng wrote:
> 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(at)talariax(dot)com>
> To: pgsql-admin(at)postgresql(dot)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
> >
> > ------------------------------------------------------ */
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl