Re: Using DSN Connection and knowing windows username

David G,

thank you.
Can you confirm if i am thinking correctly ?

So I can set up authetification to know which user is logged on and use
this as postgresql user?

But i think it will be not possible to use DSN connection with this.

Best ,
Luke

2018-06-20 15:34 GMT+02:00 David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>:

> On Wednesday, June 20, 2018, Łukasz Jarych <jaryszek(at)gmail(dot)com> wrote:
>>
>> How to know in postgresql which specific windows user is using database?
>>
>
> You cannot. All the server knows is the specific user credentials it is
> authenticating.
>
> That said you can authenticate those credentials in such a way so that
> knowing the signed on user you would also know who they are in any
> environment that uses the same authentication source - and if that source
> supplies their Windows identity you are golden. The specific setups
> involved here are outside my experience, though.
>
> David J.
>
>