I'm facing a situation where I need to transition from having dbOwner permissions to a more restricted set of permissions in order to publish a DacPack for my Database project using Visual Studio 2019.
Currently, my user, 'newlogin,' has been granted the following permissions: ddlAdmin, dbReader, and dbWriter.
However, when attempting to publish with the permissions mentioned above, I encounter the following errors:
1.An error occurs while attempting to alter the database.
2.There is an issue with creating a schema with dbo authorization.
I'm seeking guidance on what would be the minimal set of permissions required for a successful deployment of the DacPack. Your insights and suggestions would be greatly appreciated.