SYSCS_UTIL.SYSCS_MODIFY_PASSWORD system procedure

The 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. For details about NATIVE authentication, see derby.authentication.provider and "Using NATIVE authentication" in the Derby Developer's Guide.

The 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.

Syntax

SYSCS_UTIL.SYSCS_MODIFY_PASSWORD(IN PASSWORD VARCHAR(32672))

No result set is returned by this procedure.

PASSWORD: A case-sensitive password.

Execute privileges

Any user can execute this procedure.

JDBC example

CallableStatement cs = conn.prepareCall
("CALL SYSCS_UTIL.SYSCS_MODIFY_PASSWORD('shhhhh!')");
cs.execute();
cs.close();

SQL example

CALL SYSCS_UTIL.SYSCS_MODIFY_PASSWORD('shhhhh!')