Roles and passwds

Hi

I created the following role

postgres=# create role sde LOGIN PASSWORD 'passwd' SUPERUSER NOINHERIT CREATEDB;
CREATE ROLE
postgres=#

However from the command line as the postgres user I can do
-
-bash-4.1$ psql -d testdb -U sde
psql (8.4.13)
Type "help" for help.

testdb=#

So logging on to the testdb database without entering a password.

Is this expected behaviour?

More importantly my colleague can connect to the database as the sde user via a client side GUI by entering any value in the password dialogue box.

Doing the following didn't help:

testdb=# alter role sde WITH PASSWORD 'passwd';
ALTER ROLE
testdb=# alter role sde valid until 'infinity';
ALTER ROLE

How can I setup the passwd for the sde role?

Many thanks

Austen Birchall
Senior DBA
Met Office