Activities
- Connect to SQL
- Disconnect from SQL
- Add Role Access to Database
- Export From Database
- Delete Row(s) from Table
- Insert Row(s) into Table
- Remove Role Access from Database
- Import into Database
- Run Query
- Select Row(s) from Table
Connect to SQL
...
- Connection (text box editor type) (type: object): the connection object that was obtained as output from a Connect To OracleSQL activity.
- Role (value selector list) (type: string): the roles that will be added to the user. The roles will be selected from a list, after clicking the ... button. The list will display all possible roles that can be assigned to a SQL user.
The Read Only Output variable are the possible output values that the activity will provide:
- Output (type: boolean): outputs True or False if the execution was successful or not.
Delete Row(s) from Table
This activity deletes Row(s) from a SQL Server database table.
...
- Connection (text box editor type) (type: object): the connection object that was obtained as output from a Connect To OracleSQL activity.
- Role (value selector list) (type: string): the roles that will be added to the user. The roles will be selected from a list, after clicking the ... button. The list will display all possible roles that can be assigned to a SQL user.
-
The Read Only Output variable are the possible output values that the activity will provide:
- Output (type: boolean): outputs True or False if the execution was successful or not.
Execution: the activity will check if the user exists as a login on the SQL server and if found and if it already have assigned rights to the database where the activity is connected to. If the user is found and has rights over the database, the activity will revoke access on the connected database, for the given roles:
...