Unlock User

Unlock User


Unlock User

Description

This step unlocks the specified Oracle user from the oracle database.


Limitations:

On Oracle 12C database the plugin works for only CDB (Container Database). It does not work for PDB (Pluggable Database).


Configurations 

No.

Field Name

Description

1

Step Name

Name of the step.  This name has to be unique in a single workflow.


Connection:


2

Server Name/IP

The Hostname/serve name/IP of the Oracle database.

This field is mandatory.

3

Port Number

The port number of the Oracle database. Port number should be a positive integer. This field is mandatory.

4

SID/ Service name

Unique database name or service name. 

5

Username

The username having permission to Delete User (Ex:- sysdba). This field is mandatory.


Password:


6

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 drop down list. 

Else enable checkbox for Password field to appear as Text box.

7

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(drop down 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 drop down to select fields from previous steps.


Button:


8

Test Connection

Verifies whether the connection is established or not.


NOTETest Connection button does not work for previous step variables. Test Connection button only works with static values and environment variables.

Input Tab:

No.

Field Name

Description


Input Fields:


1

Username to unlock

Username of user account to be unlocked in the database. This field is mandatory.



Output Tab:

No.

Field Name

Description


Output Fields:


1

Result 

Output field to hold the result of the successful plugin execution.

Refer Appendix 1: Error Handling in IT Plugins







      Links to better reach 

            Bot Store

             EPD