[Solved] Saving password for jdbc connection

Discuss the database features
Post Reply
MPEcho
Posts: 99
Joined: Wed Sep 07, 2016 11:30 pm

[Solved] Saving password for jdbc connection

Post 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?
Last edited by Hagar Delest on Sun Aug 06, 2017 9:41 pm, edited 1 time in total.
Reason: tagged [Solved].
Libre Office 5.1.6.2 Ubuntu 16.04
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Saving password for jdbc connection

Post 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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
MPEcho
Posts: 99
Joined: Wed Sep 07, 2016 11:30 pm

Re: Saving password for jdbc connection

Post 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.
Libre Office 5.1.6.2 Ubuntu 16.04
Post Reply