...
The Add User Access to 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 for the user access. 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 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.
- Username for Access (text box editor type) (type: string): the name of the user that will receive permissions.
...
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, will grant access on the connected database, for the given roles:
Backup Database
...