IBM PureData System for Analytics, Version 7.1

The nzpassword command

Use the nzpassword command to manage passwords. The primary use is to store your password locally and thus use IBM® Netezza® 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 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 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
```