search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.58k stars 903 forks source link

Ignore Permissions option not working #8423

Open elindstr113 opened 4 years ago

elindstr113 commented 4 years ago

When comparing two databases, I have selected the "Ignore Permissions" option, but differences are still flagged, and the only difference is the permissions.

ignore_permissions

kisantia commented 4 years ago

Thanks for finding this bug! We will investigate why this option isn't being honored.

As a workaround, the permissions should be ignored if "Permissions" is unchecked in the Include Object Types image

phw198 commented 10 months ago

Although the "Ignore Permissions" checkbox has been removed (which aligns with Visual Studio): image

..., the "Include Object Types" checkbox of "Permissions" is still resolutely ignored by schema compare - so the workaround proposed by @kisantia does not work.

On exporting the .scmp file, the XML element below was not found. Even copying this across from what Visual Studio produces, reloading the .scmp file in Data Studio and recomparing does not make any difference:

      <PropertyElementName>
        <Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlPermissionStatement</Name>
        <Value>ExcludedType</Value>
      </PropertyElementName>

Version: 1.47.1 (system setup) Commit: b6f7beb01f92adaa4b79b6b6f3ac704e95cafe6e Date: 2024-01-10T02:15:02.628Z VS Code: 1.82.0 Electron: 25.8.4 Chromium: 114.0.5735.289 Node.js: 18.15.0 V8: 11.4.183.29-electron.0 OS: Windows_NT x64 10.0.19045