Using DSN Connection and knowing windows username

From: Łukasz Jarych <jaryszek(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Using DSN Connection and knowing windows username
Date: 2018-06-20 12:43:16
Message-ID: CAGv31oegb7cwKb3T5yR5558oG0tcdB8Dd4uPxrotM9tKQmp5Vw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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:

https://www.cafe-encounter.net/p2034/postgres-using-integrated-security-on-windows-on-localhost

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

Please help,
Best,
Jacek

Attachment Content-Type Size
image/png 17.2 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoff Winkless 2018-06-20 12:53:13 Re: Suggestion about logging only every n-th statement
Previous Message Sergey Burladyan 2018-06-20 12:05:59 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid