Delete LoginUser
Description
This step deletes a login user from your SQL Server 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.
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 | |
| 3 | Instance name | The instance name of MSSQL Server instance. One of the two fields Instance name or Port is mandatory. Only variables/static values are allowed. |
| 4 | Port Number | The port number of the MSSQL Server. One of the two fields Instance name or Port is mandatory. Only variables/static values are allowed. |
| 5 | Username | A username of the MSSQL Server. This field is mandatory. |
| Password | ||
| 6 | Password | Specify or select the password, as required. If the checkbox Accept Value as variable/static is selected, then the password field appears as a text box and accepts static or variable values. OR If the checkbox Accept Value as variable/static is not selected, then the password field appears as a dropdown in which you can select a field from the previous steps. |
| 7 | Other Connection Parameter | Specify multiple, semi-colon separated parameters other than the default connection parameters. Other connection parameters will be appended to the default connection parameters. Example of default connection parameters: Server Name, Password. Examples of other connection parameters: encrypt=false;trustServerCertificate=false |
| Button | ||
| 8 | Test Connection | Verifies whether the connection is established or not. NOTE: Test Connection button does not work for previous step fields. Test Connection button only works with static values and environment variables. |
| Input Fields | ||
| 1 | Login Username | Specify the Login Username that needs to be deleted. Login username is mandatory. |
| Output Fields | ||
| 1 | Result | Output field to hold the result of the successful plugin execution.For step error handling refer Error Handling This field is mandatory. |