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

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

From
Ang Sei Heng
Date:
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
>
> ------------------------------------------------------ */

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

From
Ricardo Maia
Date:
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@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
> >
> > ------------------------------------------------------ */
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl