Re: Using DSN Connection and knowing windows username

From: Łukasz Jarych <jaryszek(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Using DSN Connection and knowing windows username
Date: 2018-06-21 13:37:55
Message-ID: CAGv31ofL82btg4kgcptoctOKVkhC+w+r_FLg8N-1RncgJiZu=g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adam Brusselback 2018-06-21 14:05:20 Re: How can I stop a long run pgAgent job?
Previous Message Adrian Klaver 2018-06-21 13:33:16 Re: Using DSN Connection and knowing windows username