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.g.johnston@xxxxxxxxx>:
On Wednesday, June 20, 2018, Łukasz Jarych <jaryszek@xxxxxxxxx> 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.
