DacFx
DacFx copied to clipboard
DacFx doesn't get schema permission differences in comparison.
- SqlPackage or DacFx Version: 162.4.92
- .NET Framework (Windows-only) or .NET Core: DotNet6 (6.0.417)
- Environment (local platform and source/target platforms): Windows 10
Steps to Reproduce:
- Create SQL project from a SQL databse.
- Create a permission on a schema like -> GRANT SELECT ON SCHEMA::[dbo] TO [DBROLE_TEST]
- Compare the created SQL project with the SQL-Server (any)
Did this occur in prior versions? If not - which version(s) did it work in? No version works. No permissions differences are detected. But on Visual Studio 2022(17.11.4) it detects only schema permission differences if the schema isn't 'dbo'.
(DacFx/SqlPackage/SSMS/Azure Data Studio)