SYSCS_UTIL.SYSCS_MODIFY_PASSWORD

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.

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))

password

A case-sensitive password.

Results

This procedure does not return a result.

Execute Privileges

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.

JDBC example

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

SQL Example

The following example sets the current user’s password to baseball!:

splice> CALL SYSCS_UTIL.SYSCS_MODIFY_PASSWORD('baseball!');
Statement executed

See Also