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
