...
The Remove User Access from Database activity parameters can be provided by manual inserted values or via IN arguments or variables:
Parameters:
- CSV Roles (text box editor type) (type: collection<string>): the database-level roles that will be removed from for the user access revoking. Overrides the 'Database-level role' parameter. The values must be entered with the format: "Role1,Role2,Role3...db_owner,db_securityadmin,db_backupoperator,db_accessadmin".
- Database - level Role (value selector list) (type: string): the roles that will be deleted from revoked for 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 revoked for an SQL user.
- Username for Access (text box editor type) (type: string): the name of the user that will have the permissions revoked.
...
As mentioned above, the values for all the required parameters can be provided by IN arguments or variables. Below is an example of predefined arguments, ready to be used by the Add User Access to Database activity:
...
- The user must be written by following the "domain\username" format.
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:
Restore Database
...