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.