Neoview Database Administrator's Guide (R2.4)

Considerations for changePassword
• The changePassword command is created in the catalog.schema named neo.uaf. You must
either precede the command name with this catalog and schema name or set the default
catalog.schema to neo.uaf first: SET SCHEMA neo.uaf;
• The changePassword command must be performed by a user belonging to the MGR role.
• The changePassword command affects all segments in the Neoview platform.
• If a value for expirationDays and a value for expirationDate are both specified, the
password expiration is based on the expiration value that expires first.
Examples for changePassword
This example changes the password for a user named Henry. The new password HudsonBaY@7
is assigned to the user Henry. The expiration is set to 45 days with no expiration date specified.
CALL neo.uaf.changePassword ('Henry', 'HudsonBaY@7', 45, ' ', ?, ?);
Messages for User Management Commands
These messages are new as of Neoview Release 2.3 Service Pack 3 and are not documented in
the Neoview Messages Manual:
1
1 Invalid character in username
Cause The username specified contains an invalid character.
Effect The operation fails.
Recovery Reenter the command specifying a valid username.
2
2 Username must start with a letter or number
Cause The username specified begins with an invalid character.
Effect The operation fails.
Recovery Reenter the command specifying a valid username.
3
3 Invalid username, cannot begin with 'role.'
Cause The username specified in the command begins with the characters 'role'.
Effect The operation fails.
Recovery Reenter the command specifying a valid username that does not begin with the
characters 'role'.
4
4 Username must not be longer than 32 characters
Cause The username specified contains more than the maximum of 32 characters.
Effect The operation fails.
Recovery Reenter the command specifying a username that does not exceed the maximum
of 32 characters.
5
5 Username already exists
Cause The username specified already exists.
Effect The operation fails.
Recovery Reenter the command specifying a username that does not exist.
130 User Management Commands to Manage Multiple Neoview Users