search

johanclasson / vso-agent-tasks

Build and Release Tasks for Visual Studio Online and Team Foundation Server
MIT License
20 stars 16 forks source link

Use Windows Account in Task Azure DevOps #59

Closed lekesako closed 5 years ago

lekesako commented 5 years ago

Hi,

is it possible for a next enhancement to add a field for executing script by a windows account (like service account) ?

Now, i use a powershell with dbup library to execute sql in a remote powershell script. it will be easy if i have this functionnality

thanks

johanclasson commented 5 years ago

Since that is only usable to machines connected to a domain I am reluctant to include this feature in the task. I think the best option for you is to set up agents (or deployment groups) where you run the windows service with the windows account that has access to the DB.

lekesako commented 5 years ago

hi,

thanks for you answer. the aim to use a service account for executing the task is to manage right for this account to database. for example, i use a specifi account to INSERT/UPDATE/DELETE but not for alter/drop. So i have a release agent for executing only script and another release for executing alter/create/drop instructions for each application. if i use the windows service account, it will have too many privilege for all database.