[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: SSPI auth and mixed case usernames
From: Niels Jespersen <NJN () dst ! dk>
Date: 2019-08-30 15:06:22
Message-ID: C7FE68F4C6F44DF09ED6DE79080A0A2F () com ! citrix ! mail ! iOS
[Download RAW message or body]
<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@snowman.net><br>
<b>Dato:</b> 30. august 2019 kl. 16.21.39 CEST<br>
<b>Til:</b> Niels Jespersen <NJN@dst.dk><br>
<b>Cc:</b> Magnus Hagander <magnus@hagander.net>, \
pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.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@dst.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>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic