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}
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.
