Troubleshooting
Problem
Your company policy requires that system accounts have passwords which include special characters. In an nzsql session, you used the ALTER USER directive to specify a password that includes a special character such as an exclaimation point (!).
Symptom
To avoid displaying the password on the command line, you also used the nzpassword command to create a locally stored encrypted password. The command fails with an "event not found" error.
Resolving The Problem
When you create a user or change the password for a user, you should always use single quotes around the password as shown in the following examples:
CREATE USER user1 WITH PASSWORD '123@789';
ALTER USER jsmith WITH PASSWORD '123!4567';
This syntax applies to passwords with or without special characters. You can use a wide variety of special characters in a password.
If you choose to use the nzpassword command to maintain a cached version of the password so the user does not have to enter it upon every nzsql session, then you must also enclose the password in single quotes as shown in the following example:
nzpassword add -u jsmith -pwd '123!4567'
If you have cached the password for a user and the user has authentication problems, it may be caused by a conflict with the NZ_PASSWORD environment variable. For more information, refer to the related document referenced below.
Related Information
Historical Number
NZ415465
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21568830