Page 1 of 1
[Solved] Saving password for jdbc connection
Posted: Mon Jul 31, 2017 8:18 am
by MPEcho
I have successfully set up my database to run in a hsqldb server, multi user.
Each time I start frontend.odb, It requires the password. Is there a way to save that in the file?
Re: Saving password for jdbc connection
Posted: Mon Jul 31, 2017 10:10 pm
by Villeroy
Install my
FreeHSQLDB and run macro FreeHSQLDB.FreeHSQLDB.Main
In the dialog you can enter the password. It is saved unencrypted within the database document therefore it is a security flaw. The severity depends on the privileges that are granted to database user. For confidential data I would not even save an unencrypted password that grants read-only access.
Re: Saving password for jdbc connection
Posted: Sat Aug 05, 2017 3:27 am
by MPEcho
Villeroy wrote:Install my
FreeHSQLDB and run macro FreeHSQLDB.FreeHSQLDB.Main
In the dialog you can enter the password. It is saved unencrypted within the database document therefore it is a security flaw. The severity depends on the privileges that are granted to database user. For confidential data I would not even save an unencrypted password that grants read-only access.
Thank you for the solution. I'll have to think about security before deploying, that is certain.