转换单用户的Apache Derby数据库到一个与用户 [英] Convert single-user Apache Derby database to one with users
问题描述
我有，到现在为止，一直在本地访问Apache Derby数据库。它需要由多台计算机现在访问的，所以我觉得它应该有一个用户名/密码。
I have an Apache Derby database that, until now, has always been locally accessed. It needs to be accessed by multiple computers now, so I feel it ought to have a username/password.
- 如何利用现有的数据库和追溯添加用户
- 如何为用户本地/网络认证？
我记得几年前，翻翻自己的文档，它看起来像有留给开发者很多在这些情况下实施。
I recall looking through their docs a few years ago, and it seem like there was a lot left to a developer to implement in these cases.
要澄清更多的，对于点＃1，此页说：
To clarify more, regarding point #1, this page says:
注意：目前还没有，一旦创建数据库更改数据库所有者的方式。这意味着，如果您打算启用SQL授权运行，应确保创建数据库，只要你想成为所有者的用户。
Attention: There is currently no way of changing the database owner once the database is created. This means that if you plan to run with SQL authorization enabled, you should make sure to create the database as the user you want to be the owner.
我想这意味着我可能要创建一个名为用户创建一个新的数据库，并从原来的单用户数据库中的所有日期迁移到新的。它是否正确？是否有更简单的方法？
I think this means that I will probably have to create a new database with a named user, and migrate all date from the original single-user database to the new one. Is this correct? Is there an easier way?
另外有关问题号码二，手册上说
Also regarding question number two, the manual says
重要提示：德比内置的身份验证机制只适合开发和测试目的。强烈建议在生产系统依赖于外部目录服务，如LDAP或用于认证的用户定义的类。
Important: Derby's built-in authentication mechanism is suitable only for development and testing purposes. It is strongly recommended that production systems rely on an external directory service such as LDAP or a user-defined class for authentication.
其中，对我说，内置的身份验证是不值得使用。有没有办法，我们打算去一个LDAP集成要么，所以是有东西在两者之间这两个是值得使用？
Which, to me, says that the builtin authentication isn't worth using. There's no way we're going to go to an LDAP integration either, so is there something in-between these two that is worth using?
推荐答案
既然你提到你从一个单用户环境要一个多用户的环境中，你可能会被设置网络服务器，所以你将有两个级别的安全性来考虑：数据库认证和网络服务器验证
Since you mention you're going from a single-user environment to a multi-user environment, you're probably going to be setting up the Network Server, so you will have two levels of security to consider: database authentication, and network server authentication.
您可能想从这里开始： HTTP：//db.apache .ORG /德比/文档/ 10.8 / adminguide / cadminapps49914.html
和这里：
http://db.apache.org/derby/docs/10.8/devguide /cdevcsecure42374.html
You probably want to start here: http://db.apache.org/derby/docs/10.8/adminguide/cadminapps49914.html and here: http://db.apache.org/derby/docs/10.8/devguide/cdevcsecure42374.html
这篇关于转换单用户的Apache Derby数据库到一个与用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
