Thread: Password authentication

Password authentication

From
"Antony Paul"
Date:
Hi all,
    How to set up authentication such that user can log into database by
supplying the user name and password specified when the user is added to
databse.(Like Oracle). Password should be encrypted on transmission.
    I have an application which connects through JDBC. The database name is
test username is testuser and a password was specified at the time of
creating the user. I want to use this user and password for logging in to
application through JDBC and psql. Users connect to psql from their
machine(Some use Linux and some use Windows) or log into server using ssh
and connects locally. All these users must supply password for connecting to
test database. Everyone in internet is allowed to connect(must know
password).
     Please specify the line which will enable me to do this.

Thanks in advance

rgds
Anto Paul

Re: Password authentication

From
Bill Moran
Date:
Date: Fri, 6 Jun 2003 13:11:00 +0530

Please fix the date on your computer so your mails don't look a year old.

"Antony Paul" <antonypaul24@hotmail.com> wrote:
> Hi all,
>     How to set up authentication such that user can log into database by
> supplying the user name and password specified when the user is added to
> databse.(Like Oracle). Password should be encrypted on transmission.
>     I have an application which connects through JDBC. The database name is
> test username is testuser and a password was specified at the time of
> creating the user. I want to use this user and password for logging in to
> application through JDBC and psql. Users connect to psql from their
> machine(Some use Linux and some use Windows) or log into server using ssh
> and connects locally. All these users must supply password for connecting to
> test database. Everyone in internet is allowed to connect(must know
> password).
>      Please specify the line which will enable me to do this.

There is no single line that will accomplish this, however, if I understand
you correctly, you should set up for secure connections in your
postgresql.conf, and add the users you require.

These sections of the documentation should be helpful:
http://www.postgresql.org/docs/7.4/static/user-manag.html
http://www.postgresql.org/docs/7.4/static/runtime-config.html#RUNTIME-CONFIG-CONNECTION

--
Bill Moran
Potential Technologies
http://www.potentialtech.com