Questions on PostGreSQL Authentication mechanism...

From: dipti shah <shahdipti1980(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Questions on PostGreSQL Authentication mechanism...
Date: 2010-02-01 07:35:50
Message-ID: d5b05a951001312335p16192f28s1881406dedb5ba79@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, we have latest PostGreSQL setup and it allows everyone to connect. When
I do \du, it gives following output and it is same for all users.

TechDB=# \du
List of roles
Role name | Superuser | Create role | Create DB | Connections | Member
of
---------------+-----------+-------------+-----------+-------------+-------------
sonal | no | no | no | no limit |
{from_ldap}
sundar | no | no | no | no limit |
{from_ldap}
...
..

Moreover, anyone can connect to databases as postgres user without giving
password.

I am not aware how above setup has been made but I want to get rid of them.
Could anyone please help me in below questions?

1. When user connects to TechDB database(or any other) as a "postgres"
user, it should ask for password.
2. Remove all above users(listed with \du) and create someof users and
they will have only table creating privileges.

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Stlyz 2010-02-01 07:36:55 combine SQL SELECT statements into one
Previous Message Mads Lie Jensen 2010-02-01 07:04:58 Re: Which version will this run on?