DBA > Job Interview Questions > DERBY Java Database FAQs

How to changethe Boot Password?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How to changethe Boot Password?

You can change the boot password for the current database.

CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
'bootPasword', 'oldbpw , newbpw');

where oldbpw is the current boot password and newbpw is the new boot password. This call commits immediately; it is not transactional.

Note:
PropertyInfo.getDatabaseProperty("bootPassword"), or VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('bootPassword'), will not return the boot password.

(Continued on next question...)

Other Job Interview Questions