[DERBY-5647] NATIVE warns about password expiry for DBO

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.9.1.0
• Fix Version/s: 10.9.1.0
• Component/s: Services
• Labels: derby_backport_reject_10_8
• Assignee: Richard N. Hillegas
• Reporter: Knut Anders Hatlen
• Created: 12/Mar/12 14:23
• Updated: 05/Jul/13 12:42
• Resolved: 13/Mar/12 17:29

Description

The DBO's password cannot expire. Still, NATIVE warns that the password is about to expire.

ij> connect 'jdbc:derby:authdb;create=true;user=admin';
ij> call syscs_util.syscs_set_database_property('derby.authentication.native.passwordLifetimeMillis', '100');
0 rows inserted/updated/deleted
ij> call syscs_util.syscs_create_user('ADMIN', '%*$');
0 rows inserted/updated/deleted
ij> call syscs_util.syscs_set_database_property('derby.authentication.provider', 'NATIVE::LOCAL');
0 rows inserted/updated/deleted
ij> connect 'jdbc:derby:authdb;shutdown=true';
ERROR 08006: Database 'authdb' shutdown.
ij> connect 'jdbc:derby:authdb;user=admin;password=%*$';
WARNING 01J15: Your password will expire in 0 day(s). Please use the SYSCS_UTIL.SYSCS_MODIFY_PASSWORD procedure to change your password.

Issue Links

• relates to: DERBY-866 Derby User Management Enhancements