Re: Using DSN Connection and knowing windows username

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Using DSN Connection and knowing windows username
Дата
Msg-id CAKFQuwZFH60pwUP-YseoFx6W=yWtr8sB27mmaLo+mygmeq6+qQ@mail.gmail.com
обсуждение исходный текст
Ответ на Using DSN Connection and knowing windows username  (Łukasz Jarych <jaryszek@gmail.com>)
Ответы Re: Using DSN Connection and knowing windows username
Список 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 по дате отправления:

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Suggestion about logging only every n-th statement
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Load data from a csv file without using COPY