Force SSL / username combination - Mailing list pgsql-general

From Koen Vermeer
Subject Force SSL / username combination
Date
Msg-id 1183964731.5517.4.camel@localhost
Whole thread Raw
Responses Re: Force SSL / username combination
List pgsql-general
Hi,

I want to set up a database server that is connected to the Internet.
Therefore, I want my users to use SSL/TLS certificates. I provide these
certificates to the users, so I can control the information that is in
there. Now, I know that I can set up PostgreSQL to use SSL/TLS, but I am
unable to find a way to map a SSL/TLS certificate to a specific user.

Suppose that user A and user B both have a different, but valid
certificate. They can both use their certificate to connect to the
server, but then use the username of the other user to log in. I want to
make sure that each user is connected with his/her specific certificate.

Is there a way to set this up? If so, how?

Thanks for any pointers!

Koen


pgsql-general by date:

Previous
From: "Jasbinder Singh Bali"
Date:
Subject: Database Insertion commitment
Next
From: "A. Kretschmer"
Date:
Subject: Re: Database Insertion commitment