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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Laurette Cisneros | 2001-07-25 16:00:26 | Re: error status 139 |
Previous Message | Ang Sei Heng | 2001-07-25 09:23:08 | Fw: Help on user creation with password enable... |