Re: question about SSIS - Mailing list pgsql-general

From Tom Lane
Subject Re: question about SSIS
Date
Msg-id 29175.1243020295@sss.pgh.pa.us
Whole thread Raw
In response to Re: question about SSIS  (Magnus Hagander <magnus@hagander.net>)
Responses Re: question about SSIS
List pgsql-general
Magnus Hagander <magnus@hagander.net> writes:
> In his scenario, different clients connecting from the same subnet (so
> they can't use different pg_hba lines) need to use different
> authentication methods. (IIRC, this is an environment coming from
> Microsoft SQL Server which does support this)

Perhaps he could use the user name or database name to distinguish
them in pg_hba.conf?

> I think what he's asking for is the ability for a line in the server to
> allow multiple authentication methods, and then for the client to be
> able to specify which one of these it uses.

There's no way we could implement that without a protocol change,
and it doesn't seem worth it to me.  The idea that the client gets
to choose seems like a bad idea from a security standpoint anyhow...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to update stavaluesN columns in pg_statistics (type anyarry)
Next
From: "Mark Watson"
Date:
Subject: duplicate rows in query