db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Changing derby username and password
Date Tue, 20 Nov 2007 14:03:03 GMT
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

Mime
View raw message