Re: Authenticating from a web service call - Mailing list pgsql-general

From Bryan Montgomery
Subject Re: Authenticating from a web service call
Date
Msg-id CAPTJ3=d9iWmDmUPprnWmL9pcvsSqMVe61r-t-TpKZ-JzTmb-WA@mail.gmail.com
Whole thread Raw
In response to Re: Authenticating from a web service call  (Raymond O'Donnell <rod@iol.ie>)
Responses Re: Authenticating from a web service call
List pgsql-general
Interesting idea. However, I think this is ssl between the client and database. Given the client would be the server hosting the web service I don't think this would work for the web service client.

On Fri, Mar 16, 2012 at 2:54 PM, Raymond O'Donnell <rod@iol.ie> wrote:
On 16/03/2012 18:39, Bryan Montgomery wrote:
> Hello,
> We are looking at implementing a web service that basically makes calls
> to the database.
>
> I have been thinking about ways to secure the web service based on the
> database.
>
> I initially thought about just connecting to the database as the user
> with parameters passed through the web service - however I don't know
> how to do that other than clear text passwords.

Postgres supports connections over SSL - will this do the job?

http://www.postgresql.org/docs/9.1/static/ssl-tcp.html

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: [BUGS] Altering a table with a rowtype column
Next
From: Edoardo Panfili
Date:
Subject: Re: Is it even possible?