When working with SQL Source Control Projects, SQL Change Automation PowerShell requires the same permissions as SQL Compare:
Permissions required to use SQL Compare
Build step specific:
Besides the permissions listed above please note that the following permissions might be required when doing the schema validation:
- sysadmin if using the Temporary Server option (because when it creates the Database it sets TRUSTWORTHY ON).
- db_owner if using the Temporary Database option.