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

From David G. Johnston
Subject Re: Using DSN Connection and knowing windows username
Date
Msg-id CAKFQuwZFH60pwUP-YseoFx6W=yWtr8sB27mmaLo+mygmeq6+qQ@mail.gmail.com
Whole thread Raw
In response to Using DSN Connection and knowing windows username  (Łukasz Jarych <jaryszek@gmail.com>)
Responses Re: Using DSN Connection and knowing windows username  (Łukasz Jarych <jaryszek@gmail.com>)
List pgsql-general
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: Andreas Kretschmer
Date:
Subject: Re: Suggestion about logging only every n-th statement
Next
From: Adrian Klaver
Date:
Subject: Re: Load data from a csv file without using COPY