Oracle: Reset User Passwordd
Description
This step resets the password of Oracle user on the given Oracle database.
Limitations
On Oracle 12C database the plugin works for only CDB (Container Database) and not for PDB (Pluggable Database).
Configurations
| Field name | Description |
|---|---|
| Step Name | Specify a unique step name. |
| CONNECTION | |
| Server Name/IP | The Hostname/serve name/IP of the Oracle database. This field is mandatory. |
| Port Number | The port number of the Oracle database. Port number should be a positive integer. This field is mandatory. |
| SID/ Service name | Unique database name or service name. |
| Username | The username having permission to Delete User. For example, sysdba. This field is mandatory. |
| Password: | |
| Checkbox: Accept Value as variable/static | Leave checkbox unchecked to accept Password value from a field in the previous steps of the stream using a dropdown list. Else enable checkbox for Password field to appear as Text box. |
| Password | The Password to the username to authenticate to Oracle database. Password is entered using a widget. The widget handles both Text Var (static value or environment variable) and Combo (dropdown containing values from previous steps). This field is mandatory. If checkbox above is enabled Password field appears as Text box. Else if checkbox above is disabled Password field appears as a dropdown to select fields from previous steps. |
| Test Connection | Verifies whether the connection is established or not. Note: Test Connection button does not work for previous step variables. Test Connection button only works with static values and environment variables. |
| INPUT TAB: | Input fields |
| Username for password reset | Username to reset password. |
| New Password | Provide the new password to be set. |
| OUTPUT TAB: | Output field |
| Result | Output field to hold the result of the successful plugin execution. For details, see Error Handling in IT Plugins |