How to set up multiple users environment on SQL server/Postgresql BE

[jaryszek]

Hi,

When i am connecting using DSN i have one user on Postgresql database.
How the true concept shoud look like?

Have in Access FE login form and log into database based on credentials?
Or maybe set up non DSN connections?



What is your approach?

Best,
Jacek

[pbaldy]

You mean security on the back end? I use Windows authentication and set up authorized users/groups in SQL Server.