Search Postgresql Archives

Re: SSPI auth and mixed case usernames

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Greetings,

* Niels Jespersen (NJN@xxxxxx) 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 all lowercase).
>    In other words, Windows usernames one day entered as XYz, the next day
>    entered as xYz, should logon to Postgres user xyz.

You just have to make sure that the users tell whatever program they're
using to connect to PG (like psql, pgAdmin, whatever) that their PG
username is 'xyz'.  If they try to log in as 'XYZ' then that's gonna be
a different PG user.

If you have some other application that's being used to connect to PG
then you could do the lowercase in the app...

Thanks,

Stephen

Attachment: signature.asc
Description: PGP signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux