From: | Bill Moran <wmoran(at)potentialtech(dot)com> |
---|---|
To: | "Antony Paul" <antonypaul24(at)hotmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Password authentication |
Date: | 2004-08-14 23:26:30 |
Message-ID: | 20040814192630.597fc265.wmoran@potentialtech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)hotmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Welty | 2004-08-15 01:13:43 | understanding your tools |
Previous Message | Mike Mascari | 2004-08-14 22:04:52 | Re: PostgreSQL 8.0 Feature List? |