Security problem with Postgres sql

From: DEEPANSHU GARG <deepanshu(dot)garg(at)tatainfotech(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: Saba Alam <saba(dot)alam(at)tatainfotech(dot)com>
Subject: Security problem with Postgres sql
Date: 2003-03-21 11:14:07
Message-ID: Pine.LNX.4.04.10303211639290.731-100000@nepzmail.in.tatainfotech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,
We have a problem when logging in postgresql.
We are setting the user id and password using Create User command.
Now when we login the postgresql using
$psql -U username databasename
it does'nt prompt for the password but connects to the database.
The password is correctly set and we examined the pg_shadow table also
where it has been stored in the encrypted format. Please help us with
this.

Also when we log in the Psql with the small -u option it shows the option
is deprecated , use -U option , prompts for the user id and passsword but
never validates the password.

If someone else has faced this problem please help us out. This is very
ugently required.

Regards,
Deeps

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2003-03-21 11:57:47 Bug #915: problem with returning setof with double precision values
Previous Message Diego Cattelan 2003-03-21 08:41:55 alter table