Password visible in Connection string ODBC PostgreSQL
Posted: Tue 12 Oct 2021 14:29
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?
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?