Re: SSPI auth and mixed case usernames

2019-08-30 Thread Niels Jespersen
: 30. august 2019 kl. 16.21.39 CEST Til: Niels Jespersen Cc: Magnus Hagander , pgsql-general@lists.postgresql.org Emne: Re: SSPI auth and mixed case usernames Greetings, * Niels Jespersen (n...@dst.dk) wrote: >    Hello Magnus >    Thank you for your prompt reply.  >    I’m n

Re: SSPI auth and mixed case usernames

2019-08-30 Thread Magnus Hagander
On Fri, Aug 30, 2019 at 3:00 PM Niels Jespersen wrote: > Hello Magnus > > Thank you for your prompt reply. > > I’m not sure I understand your last statement. I want to achieve that > regardless of the case of the entered username is logged into the same > Postgres user (whose name is created in a

Re: SSPI auth and mixed case usernames

2019-08-30 Thread Stephen Frost
Greetings, * Niels Jespersen (n...@dst.dk) wrote: >Hello Magnus >Thank you for your prompt reply.  >I’m not sure I understand your last statement. I want to achieve that >regardless of the case of the entered username is logged into the same >Postgres user (whose name is create

Re: SSPI auth and mixed case usernames

2019-08-30 Thread Niels Jespersen
entered as XYz, the next day entered as xYz, should logon to Postgres user xyz. Niels Fra: Magnus Hagander Dato: 30. august 2019 kl. 13.31.33 CEST Til: Niels Jespersen Cc: pgsql-general@lists.postgresql.org Emne: Re: SSPI auth and mixed case usernames On Fri, Aug 30, 2019 at 1

Re: SSPI auth and mixed case usernames

2019-08-30 Thread Magnus Hagander
On Fri, Aug 30, 2019 at 1:27 PM Niels Jespersen wrote: > Hello > > Postgresql 11.2 on Windows. > > I have a user mapping i pg_hba.conf > > sspi map=domain > > In pg_ident.conf, I have the following: > > domain/^(([A-Z|a-z]{3}[A|a]?)|([Xx]\d{2}))@DOMAIN$\1 > > This maps windows logonna