Concealing Password Input

Use the isql --conceal option, with the ":?" wildcard characters, to conceal the passwords you set when you create or alter users.

  1. Start isql with the --conceal option before you create a user or change a password for a user.
    For example, at the ny_rs Replication Server for the test_2 user, enter:
    isql -Sny_rs -Utest_2 --conceal
    Password:
  2. Enter the alter user or create user command, and instead of typing a password in clear text, enter the :? wildcard pair of characters at the beginning of the command line for password entry.
    For example, to change the password for the test_2 user:
    alter user test_2
    set password
    :?
    verify password
    :?
    go
    Optionally, use the double wildcard character pair ":?:?" within the same line to prompt for confirmation of the new password. For example:
    alter user test_2
    set password
    :?:?
    verify password
    :?
    go 
    isql prompts you for the information to replace the wildcard pair of characters. Each :? wildcard character pair you enter results in a separate :? prompt. Replication Server does display any characters you type at the :? prompt.
  3. Enter the new password at the first :? prompt, which corresponds to the set password clause, and enter the old password at the second :? prompt, which corresponds to the verify password clause.
    :? new_pasword
    :? old_pasword
    If you use the double ":?:?" character pairs option in the command, you see:
    :? 
    Confirm :?
    :?
    Enter the new password at the first :? prompt corresponding to the set password clause, enter the new password again at the second Confirm :? prompt, and enter the old password at the third :? prompt corresponding to the verify password clause.
    If the password you enter complies with the password security requirements, you see:
    User 'test_2' is altered.