Re: Using DSN Connection and knowing windows username - Mailing list pgsql-general

From Łukasz Jarych
Subject Re: Using DSN Connection and knowing windows username
Date
Msg-id CAGv31ofhsQ3rGWbfuGD1kmYJUrmYSWThf6jMqHHLZmPHgiL0hw@mail.gmail.com
Whole thread Raw
In response to Re: Using DSN Connection and knowing windows username  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Using DSN Connection and knowing windows username  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
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@gmail.com>:
On Wednesday, June 20, 2018, Łukasz Jarych <jaryszek@gmail.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.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Plan output: actual execution time not considering loops?
Next
From: Jonathan Marks
Date:
Subject: tsvector field length limitation