DacFx icon indicating copy to clipboard operation
DacFx copied to clipboard

DacFx doesn't get schema permission differences in comparison.

Open Aldebaran91 opened this issue 5 months ago • 6 comments

  • 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:

  1. Create SQL project from a SQL databse.
  2. Create a permission on a schema like -> GRANT SELECT ON SCHEMA::[dbo] TO [DBROLE_TEST]
  3. 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)

Aldebaran91 avatar Sep 20 '24 10:09 Aldebaran91