Oracle: Create User
Description
This plugin is used to create a new oracle user.
Prerequisites
- Oracle 11g/12c environment on Windows
- Oracle 12c environment on Linux.
- Sufficient privileges to create the tablespace(preferably sysbda privileges).
- ojdbc6.jar must be present in lib folder of Process Studio as well as AE agent.
- While testing on Oracle 12c Windows/Linux the pluggable database should be open before performing any action.
- For connecting to the Oracle Server, OracleOraDB12homeTNSListener & OracleServiceORCL should be started.
Limitations
On Oracle 12C database the plugin works for only CDB (Container Database). It does not work for PDB (Pluggable Database).
Configurations
| Field name | Description |
|---|---|
| Step Name | Specify a unique step name. |
| CONNECTION | |
| Server Name/IP | The IP or fully qualified domain name of the Oracle database machine. 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. This field is mandatory. |
| Username | The username having permission to create new User. For example: sysdba. This field is mandatory. |
| Password: | |
| Accept Values from fields | Enable this checkbox to accept Password value from a field in the previous steps of the stream using a drop down list. |
| Password | The password for the Oracle username to authenticate. This field is mandatory. Password is entered using a widget called SecuredComboVar. 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 Var. 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 |
| New User | Username which is to be created. This field is mandatory. |
| New Password | Password for the new user to be created. This field is mandatory. |
| ADVANCED INPUT TAB: | Advanced Input fields |
| Default Table space | Name of the Default table space. If quota (K/M) is set then Default Tablespace is mandatory. Note: The create user plugin executes successfully, for any combination of Temporary Tablespabe, Default tablespace and Quota fields” except when, Quota is provided and Default tablespace is missing. A popup window with error message “Invalid combination of Temporary Tablespabe, Default tablespace and Quota fields” is shown. |
| OUTPUT TAB: | Output fields |
| Result | Output field to hold the result of the successful plugin execution. |