hsql script文件加密

HSQLEncryption

最新推荐文章于 2023-07-10 16:49:42 发布

最新推荐文章于 2023-07-10 16:49:42 发布 · 248 阅读

文章标签：

#HSQLDB

数据库专栏收录该内容

20 篇文章

订阅专栏

本文介绍了一种在HSQLE中使用BINARY或COMPRESSED格式加密脚本文件的方法，并提供了更改默认空密码的方式，以此来保护数据库免受简单用户的直接查看和修改。

现在的应用中并没有对hsqldb的script文件进行加密，也没有改变初始的用户名和密码。如果有需要的话，下面的这段话会有作用。

Okay, I think I found the solution. I will write it down for other people that are interested.

When you create your database, execute this statement to the database:

SET SCRIPTFORMAT BINARY

(BINARY can also be COMPRESSED or TEXT)

This way you "encrypt" your database into binary data.

With the command "SET PASSWORD myp@ssword" you can change your password (default password is an empty String). So this way your database is password protected in a good way.

I'm not sure, but I do not think this way your database 100% proof. You can probably write a program to read the (binary) database and then export it as default text. But this is a way to prevent simple users from looking / changing directly into the database (which you really don't want if you have passwords stored in it).

So if anyone has other solutions to REALLY encrypt it, feel free to post.