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
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
On 06/21/2018 12:17 AM, Łukasz Jarych wrote:
Hmm one problem.
How to distinct value for specific user?
I created new table in postgresql and when user is login into system New
value is added to field "System_user".
But how to show postgresql database that should use the specific value
(for inp
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.
Best,
Luke
2018-06-21 9:17 GMT+02:00 Łukasz Jarych :
> Hmm one problem.
>
> How to distinct value fo
Hmm one problem.
How to distinct value for specific user?
I created new table in postgresql and when user is login into system New
value is added to field "System_user".
But how to show postgresql database that should use the specific value (for
inputing data user, not for others?).
Best,
Luke
2
Thank you Adrian,
In the meantime just an idea, but could you capture the system user in a
> table in Access and use that to pass on to Postgres?
Brilliant ! simple and genious!
The purpose of it is to have history log table with DML and DDL changes
using triggers.
Best,
Luke
2018-06-21 0:
On 06/20/2018 07:06 AM, Łukasz Jarych wrote:
David G,
thank you.
Can you confirm if i am thinking correctly ?
So I can set up authetification to know which user is logged on and use
this as postgresql user?
Only if the system user is a postgres user or can be mapped to one:
https://www.post
David G,
thank you.
Can you confirm if i am thinking correctly ?
So I can set up authetification to know which user is logged on and use
this as postgresql user?
But i think it will be not possible to use DSN connection with this.
Best ,
Luke
2018-06-20 15:34 GMT+02:00 David G. Johnston :
> O
On Wednesday, June 20, 2018, Łukasz Jarych 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
