How to ignore/exclude security object when publishing DACPAC in SSDT

See more:

C#

SQL

ASP.NET4

Hi All,

I have created new SSDT project (.NET Framework 4.7.2) for publishing DB changes using DACPAC file. I have used all the advanced options to exclude/ignore db users, permissions and other security objects. They are getting excluded when I publish manually using publish option. But when I use DACPAC file it is not excluding users, permission and complete security objects, its dropping everything.

What I have tried:

I tried to modify the advanced options in project properties --> Debug --> selected Drop object in target but not in source and Advance settings I excluded all security objects and selected do not drop security related objects as well. But still when I upgrade db using DACPAC it is dropping security objects.

After making above settings Im just building the project to get DACPAC file in Release folder. Is that correct way to get DACPAC file?

I have tried to google but couldn't find correct solution. Can you please help me on this.

Thanks in Advance!!!