[Solved] Saving password for jdbc connection

Discuss the database features

[Solved] Saving password for jdbc connection

Postby MPEcho » Mon Jul 31, 2017 8:18 am

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 Ubuntu 16.04
MPEcho
 
Posts: 92
Joined: Wed Sep 07, 2016 11:30 pm

Re: Saving password for jdbc connection

Postby Villeroy » Mon Jul 31, 2017 10:10 pm

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, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 25834
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Saving password for jdbc connection

Postby MPEcho » Sat Aug 05, 2017 3:27 am

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 Ubuntu 16.04
MPEcho
 
Posts: 92
Joined: Wed Sep 07, 2016 11:30 pm


Return to Base

Who is online

Users browsing this forum: No registered users and 5 guests