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. |
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 analytic scripts run in Robots, or in legacy server scripts.
You can use the PASSWORD analytic tag to prompt for a password when a user schedules an analytic script in Robots.
You can use the SET PASSWORD command to specify passwords in legacy server scripts.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article