Postgres Pro
Downloads
Home   >   mailing lists

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 CAGv31ofL82btg4kgcptoctOKVkhC+w+r_FLg8N-1RncgJiZu=g@mail.gmail.com
Whole thread Raw
In response to Re: Using DSN Connection and knowing windows username  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
Hi ,

That would work as long as the user name and password used to login into Access are also recognized by Postgres.

I created users in postgresql and connecting to database using windows username and common password.

Thank you for help.

Best,
Luke 

2018-06-21 15:33 GMT+02:00 Adrian Klaver <adrian.klaver@aklaver.com>:
On 06/21/2018 01:33 AM, Łukasz Jarych wrote:
Hi Guys,

the best option here i think is to:

1. Create users login in Access
2. Use DSN-less odbc connection.
3. When user is login to Access i am taking password and using it in postgresql BE.

 That would work as long as the user name and password used to login into Access are also recognized by Postgres.



Best,
Luke


--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Using DSN Connection and knowing windows username
Next
From: Adam Brusselback
Date:
Subject: Re: How can I stop a long run pgAgent job?