Oracle: Delete User
Description
This step deletes a user from your Oracle database instance. You provide the username to remove. Use this step in offboarding workflows that revoke database access, clean up unused accounts, or remove service accounts that are no longer needed.
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. |
| Username | The username having permission to Delete User (Ex:- 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 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 |
| Username to delete | Username which is to be deleted from the database. This field is mandatory. |
| OUTPUT TAB: | Output field |
| Result | Output field to hold the result of the successful plugin execution. |