Hi Jason,
Derby supports 3 ways of managing users. You will have to select one of
these schemes:
1) Via username/password pairs stored in the database. In this scheme
you add new users and change passwords with the Derby system procedure
SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY.
2) Via an external LDAP service. The LDAP service should supply tools
for configuring users and passwords.
3) Via a customer-coded plugin. Here you write your own scheme for
managing usernames and passwords.
The short answer to your question is "yes". The long answer is this: how
you configure users/passwords depends on the authentication scheme you
have selected. Please see the "Derby and Security" section of the Derby
Developer's Guide (the link is given below) for more detail on how to
setup these authentication schemes.
Hope this helps,
-Rick
Jason D'cruz wrote:
Thanks Rick,
Our requirement is to create a new user or to change the password for an
existing user.Is that possible?
Regards,
Jason
Rick Hillegas-2 wrote:
Jason D'cruz wrote:
I'm writing a java application using Derby embedded and network drivers.
Initially i access the database using a default username and password.
How can i change the username and password to access the database?
Or can i create a new user with the same privileges and delete the old
one?
Thanks,
Jason
Hi Jason,
There is no way to migrate ownership of schema objects from one user to
another. In particular, there is no way to migrate the ownership of the
database from its creator to another user. However, you may be able to
accomplish much of what you want by GRANTing sufficient privileges to
the new user. You can certainly create new users who are allowed to do
work in the database.
For more detail, please see the "Derby and Security" section of the
Derby Developer's Guide: http://db.apache.org/derby/docs/10.3/devguide/
Hope this helps,
-Rick
