<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from text --><style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<div>
<div style="">
<div dir="auto">
<div dir="auto">
<div id="x_signature-div-AAF3C509-54F0-4EB8-9EA5-8FABFE13AF66" dir="auto">Ok, yes. It’s s server for analytics running R. So users speecify their oen connection string. My initial thought was to leave out username in the connection string, but I think now to
specify username in lowercase. </div>
<div id="x_signature-div-AAF3C509-54F0-4EB8-9EA5-8FABFE13AF66" dir="auto"><br>
</div>
<div id="x_signature-div-AAF3C509-54F0-4EB8-9EA5-8FABFE13AF66" dir="auto">Thank you, and Magnus also. </div>
<div id="x_signature-div-AAF3C509-54F0-4EB8-9EA5-8FABFE13AF66" dir="auto"><br>
</div>
<div id="x_signature-div-AAF3C509-54F0-4EB8-9EA5-8FABFE13AF66" dir="auto">Niels <br>
<br>
</div>
</div>
</div>
</div>
<hr>
<div dir="auto" style=""><br>
<b>Fra:</b> Stephen Frost <sfrost(at)snowman(dot)net><br>
<b>Dato:</b> 30. august 2019 kl. 16.21.39 CEST<br>
<b>Til:</b> Niels Jespersen <NJN(at)dst(dot)dk><br>
<b>Cc:</b> Magnus Hagander <magnus(at)hagander(dot)net>, pgsql-general(at)lists(dot)postgresql(dot)org <pgsql-general(at)lists(dot)postgresql(dot)org><br>
<b>Emne:</b> Re: SSPI auth and mixed case usernames<br>
</div>
<br>
</div>
<font size="2"><span style="font-size:10pt;">
<div class="PlainText">Greetings,<br>
<br>
* Niels Jespersen (NJN(at)dst(dot)dk) wrote:<br>
> Hello Magnus<br>
> Thank you for your prompt reply. <br>
> I’m not sure I understand your last statement. I want to achieve that<br>
> regardless of the case of the entered username is logged into the same<br>
> Postgres user (whose name is created in all lowercase).<br>
> In other words, Windows usernames one day entered as XYz, the next day<br>
> entered as xYz, should logon to Postgres user xyz.<br>
<br>
You just have to make sure that the users tell whatever program they're<br>
using to connect to PG (like psql, pgAdmin, whatever) that their PG<br>
username is 'xyz'. If they try to log in as 'XYZ' then that's gonna be<br>
a different PG user.<br>
<br>
If you have some other application that's being used to connect to PG<br>
then you could do the lowercase in the app...<br>
<br>
Thanks,<br>
<br>
Stephen<br>
</div>
</span></font>
</body>
</html>