Skip to content

v2.2.0

Latest

Choose a tag to compare

@github-actions github-actions released this 21 Sep 09:26
4d50164

Added

  • Added support for connecting to a Azure SQL database.
  • Added UniquenessCheck/uniquenessCheckEntraIdChecksSqlAndEntraId.ps1 for combined uniqueness validation against SQL and Microsoft Entra ID.
  • Added UniquenessCheck/README.md with usage and configuration details for the uniqueness check scripts.
  • Added SupportingFiles/createTableBlocklist.sql as the renamed SQL table setup script.

Changed

  • Renamed blocklist uniqueness scripts from CheckOnExternalSystems/* to UniquenessCheck/* and updated documentation references accordingly.
  • Replaced terminology across the repository from Blacklist/blacklist to Blocklist/blocklist.

Fixed

  • Fixed SQL injection vulnerability in UniquenessCheck/uniquenessCheckAdChecksSql.ps1, UniquenessCheck/uniquenessCheckAdChecksSqlAndAd.ps1 and UniquenessCheck/uniquenessCheckEntraIdChecksSqlAndEntraId.ps1 by escaping single quotes in account values before using them in SQL WHERE clauses (e.g., names like "in 't veld" or "van 't slot").
  • Fixed filter errors and injection for values containing single quotes in the Active Directory filter of UniquenessCheck/uniquenessCheckAdChecksSqlAndAd.ps1 and the Microsoft Graph OData filter of UniquenessCheck/uniquenessCheckEntraIdChecksSqlAndEntraId.ps1.