SYSCS_UTIL.SYSCS_MODIFY_PASSWORD system procedure is called by a
user to change that user’s own password.
This procedure is used in conjunction with NATIVE authentication.
derby.authentication.native.passwordLifetimeMillis property sets
the password expiration time, and the
derby.authentication.native.passwordLifetimeThreshold property sets
the time when a user is warned that the password will expire.
SYSCS_UTIL.SYSCS_MODIFY_PASSWORD(IN password VARCHAR(32672))
A case-sensitive password.
This procedure does not return a result.
Any user can execute this procedure.
As of this writing, your administrator must grant a user execute permission on this procedure before that user can successfully modify his or her password.
CallableStatement cs = conn.prepareCall( "CALL SYSCS_UTIL.SYSCS_MODIFY_PASSWORD('baseball!')"); cs.execute(); cs.close();
The following example sets the current user’s password to
splice> CALL SYSCS_UTIL.SYSCS_MODIFY_PASSWORD('baseball!'); Statement executed