The nzpassword command

Deployment options: IBM Netezza Appliance

Use the nzpassword command to manage passwords. The primary use is to store your password locally and thus use the CLI commands without having to type your password on the command line.

Syntax

The nzpassword command uses the following syntax:

nzpassword subcmd [subcmd options]

Inputs

The nzpassword command takes the following inputs:

Table 1. The nzpassword input options
Input	Description
nzpassword add `options`	Adds a locally cached password.
nzpassword delete `options`	Removes the locally cached passwords.
nzpassword resetkey `options`	In normal system operation and without any options, this command creates a unique client key and re-encrypts the user passwords with the new key. If you have an existing password file that was created by using older (pre-Release 6.0 or pre-Release 4.6.6 clients), this command also converts the old Blowfish-encrypted passwords to AES-256-encrypted passwords. The client key that is used for the encryption is auto-generated. For more information about using encrypted passwords, see Encrypted passwords.
nzpassword show	Displays cached passwords.

Options

The nzpassword command uses the following options:

Table 2. The nzpassword options
Command	Option	Description
nzpassword add	-host `name`	Specifies a host name or IP address [NZ_HOST].
	-u `user`	Specifies the Netezza Performance Server user name [NZ_USER].
	-pw `password`	Specifies the user password [NZ_PASSWORD].
	-timeout `secs`	Specifies how long to wait for the command to time out (in seconds) before returning an error. The default is 300.
nzpassword delete	-u `user`	Specifies the database user name [NZ_USER].
	-host `name`	Specifies a host name or IP address [NZ_HOST].
	-all	Deletes all cached passwords.
nzpassword resetkey	-none	If you must downgrade to a previous release, or if your client users must support mixed releases of clients, you can use the nzpassword resetkey -none command to convert AES-256-encrypted passwords to Blowfish-encrypted passwords. For more information about using encrypted passwords, see Encrypted passwords.
nzpassword show	N/A	Shows the cached passwords for the current user. The command displays the message `No cached passwords` if there is none to display.

Description

The nzpassword command does the following:

Privileges required: You must be logged in as nz or any valid Linux® account for the Netezza Performance Server system.
Common tasks: Use the nzpassword command to store a local version of your password.

Related commands

Use with the CREATE USER or ALTER USER command.

Usage

The following provides sample usage:

To add a password, enter:

nzpassword add -u user -pw password -host nzhost

To delete a password, enter:
```
nzpassword delete -u user -host nzhost
```
To show the command options, enter:
```
nzpassword show
```
To reset the client key and create new encryptions of the passwords, enter:
```
nzpassword resetkey
```