PASSWORD command

Creates a password definition, without a password value, that prompts users for a password while a script is running.

Syntax

PASSWORD num <prompt>

Parameters

Name	Description
num	A value from 1 to 10 that uniquely identifies the password definition.
prompt optional	A valid character expression to display in the dialog box used to prompt for the password. Enclose literal strings in quotation marks. If prompt is omitted, a default dialog box with no message is displayed.

Name

Description

num

A value from 1 to 10 that uniquely identifies the password definition.

prompt

optional

A valid character expression to display in the dialog box used to prompt for the password. Enclose literal strings in quotation marks.

If prompt is omitted, a default dialog box with no message is displayed.

Examples

Prompting for password information

You use the PASSWORD command to prompt the user for the three passwords required in a script. Once the user enters the required passwords, the script can complete the remaining processing without interruption:

PASSWORD 1 "Enter the password for the Receivables database"
PASSWORD 2 "Enter the password for the Payables database"
PASSWORD 3 "Enter the password for the Customer database"

Specifying a password when refreshing an Analytics table

You combine the PASSWORD command with the REFRESH command to update a password-protected data file:

PASSWORD 1 "Password:"
REFRESH Abc PASSWORD 1

Specifying a password to define a server table

You use the PASSWORD command with the DEFINE TABLE DB command to define a server table via AX Connector, which requires one password for the database profile, and another for the associated server profile:

DEFINE TABLE DB SOURCE Inventory_DBProfile PASSWORD 9 PASSWORD 3

Remarks

When to use PASSWORD

Use the PASSWORD command to prompt a user to enter password information before a script accesses, imports, or refreshes password-protected data.

You can create up to ten different password definitions in a script .

PASSWORD is useful if:

you want to avoid typing an actual password in a script, which the SET PASSWORD command requires
individual users need to enter distinct passwords

How passwords are stored

User-entered passwords are temporarily and securely stored in memory.

When a user types a password into the prompt dialog box, the characters are masked using asterisks (*). The password does not appear in either the script or the log.

Storing passwords for server-based analytics

The PASSWORD command is not supported in analytics run in Robots or on AX Server, or in legacy server scripts.

You can use the PASSWORD tag to prompt for a password when a user schedules an analytic in Robots or on AX Server.

You can use the SET PASSWORD command to specify passwords in legacy server scripts.