Page 1 of 1

Password visible in Connection string ODBC PostgreSQL

Posted: Tue 12 Oct 2021 14:29
by armmax
Hello

I am using the ODBC Driver for PostgreSQL in Excel on Mac.
I configured the System DSN and it worked.
I then created a new database connection in Excel using the ODBC.
After triggering it for the first time, I got a pop-up asking for the login and password to the database.
I added them but then I realized that they had been added to the connection string.
The login and password to our database is visible there and accessible to anyone who would get the excel file.

How could I change this?

Re: Password visible in Connection string ODBC PostgreSQL

Posted: Wed 13 Oct 2021 12:24
by evgeniym
Hi.
Unfortunately, we cannot influence the behavior of MS Excel, so if you do not want other users to see the password, then you have do not save it in the DSN, but enter it every time you establish a connection.
Regards,
Evgeniy