I'm using Visual Studio 2022(17.4.1) and I'm importing existing database to a project. With that I can publish it and everything goes well(tables, users, roles, procedures etc.) but I'm experiencing problem that the permissions aren't really being published to the target database(which is Synapse). It looks like SSDT is skipping every 'GRANT' statement.
I've tried changing publishing settings. Also I did it in post-deployment script but it is not efficient as I need to check through whole Security directory for every grant.
