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

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

From: Ricardo Maia <rmaia(at)criticalsoftware(dot)com>
To: Ang Sei Heng <seiheng(at)talariax(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Fw: Help on user creation with password enable...
Date: 2001-07-25 10:18:11
Message-ID: 01072511181101.15379@valkyrie (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

pgsql-admin by date

Next:From: Laurette CisnerosDate: 2001-07-25 16:00:26
Subject: Re: error status 139
Previous:From: Ang Sei HengDate: 2001-07-25 09:23:08
Subject: Fw: Help on user creation with password enable...

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