| From: | Niels Jespersen <NJN(at)dst(dot)dk> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | SSPI auth and mixed case usernames |
| Date: | 2019-08-30 11:27:06 |
| Message-ID: | 3967181ED595B445B1E39718204FD4BD0122BAD97D@SRVEXC5.dst.local |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 logonname til a postgres username. Hower, for reasons I cannot explain, sometimes the username comes in all-lowercase, at other times it comes all-caps. This is dependant on the Windows host the client is connected to.
I do not want to create both XXX and xxx as users on Postgres. I would prefer to translate alle usernames to lowercase in the map.
Is that possible, and if so, how?
Regards Niels Jespersen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2019-08-30 11:31:17 | Re: SSPI auth and mixed case usernames |
| Previous Message | Luca Ferrari | 2019-08-30 11:08:42 | Re: "storing" a calculated value in plsql function ? |