Postgres Pro
Downloads
Home   >   mailing lists

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

From Łukasz Jarych
Subject Using DSN Connection and knowing windows username
Date
Msg-id CAGv31oegb7cwKb3T5yR5558oG0tcdB8Dd4uPxrotM9tKQmp5Vw@mail.gmail.com
Whole thread Raw
Responses Re: Using DSN Connection and knowing windows username  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
Hi,

i am using windows server 2012 and connecting from Access FE to Postgresql using DSN connection. 

When i am using "select current_user;" in postgresql i have always user "postgres" because it is my default user for database. 

How to know in postgresql which specific windows user is using database? 
How to solve this? 

I tried to use method from here:


but this is only to avoid inputing password by specific windows server user. 
(and this is not working also).

Please help,
Best,
Jacek 
Attachment

pgsql-general by date:

Previous
From: Janning Vygen
Date:
Subject: Suggestion about logging only every n-th statement
Next
From: Geoff Winkless
Date:
Subject: Re: Suggestion about logging only every n-th statement