Skip to content
Advertisement

Insufficient user permission performing an operation on Sql Server Azure

I am trying to re-run migration on a newly created DB in azure. DB, User, and all privileges were created from scratch. I basically granted all operation permission to the user including DB admin roles for read and write: (basically tried all these)

But in the end I am still seeing error performing this specific operation. (logs from Azure DevOps)

Advertisement

Answer

Not sure what extra privileges db_owner gives which was missing from what I tried above, but this fixed my problem:

I post it here hopefully it could help anyone.

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement