AzSqlAccessSync

Synchronizes and verifies Azure SQL Server login, user, role, and permission access based on JSON configuration files. Supports Entra ID (external) and SQL logins, database/server roles, and VIEW permissions.

Minimum PowerShell version

7.0

Installation Options

Owners

• wabby80

Copyright

(c) 2026 Bjørn Christopher Wang. Licensed under the MIT License.

Package Details

FileList

• AzSqlAccessSync.nuspec
• AzSqlAccessSync.psd1
• AzSqlAccessSync.psm1
• CHANGELOG.md
• LICENSE
• Logins\developers_DevOnly.json
• Logins\monitoring.json
• Logins\myapp.json
• Logins\reporting.json
• Logins\support_ProdOnly.json
• Logins\vm-sql.json
• Private\Add-SyncAction.ps1
• Private\Expand-EntraPrincipalChain.ps1
• Private\Expand-ResolvedEntraObject.ps1
• Private\Expand-SqlRoleChain.ps1
• Private\Get-AzSqlToken.ps1
• Private\Get-EntraGroupPimEligibleMembers.ps1
• Private\Get-SqlAccessDriftReport.ps1
• Private\Get-SqlAccessSnapshot.ps1
• Private\Get-SqlServerEntraAdmin.ps1
• Private\Import-LoginConfig.ps1
• Private\Import-RoleConfig.ps1
• Private\Initialize-ImportExcelModule.ps1
• Private\Initialize-PimGraphConnection.ps1
• Private\Invoke-SqlAccessQuery.ps1
• Private\Remove-SqlAccessDrift.ps1
• Private\Remove-SqlOrphanedLogin.ps1
• Private\Resolve-EntraObject.ps1
• Private\Sync-SqlDatabaseUser.ps1
• Private\Sync-SqlExecutePermission.ps1
• Private\Sync-SqlRoleMembership.ps1
• Private\Sync-SqlServerLogin.ps1
• Private\Sync-SqlViewPermission.ps1
• Private\Test-AzureSqlServer.ps1
• Private\Test-EntraIdPrincipal.ps1
• Profiles\example-prod.json
• Profiles\example-vm.json
• Profiles\example.json
• Public\Get-SqlAccessReport.ps1
• Public\Sync-SqlRoles.ps1
• Public\Sync-SqlUserAccess.ps1
• README.md
• Roles\DatabaseCreators.json
• Roles\JobsDb.json
• Roles\Support.json
• Roles\vm-Support.json

Version History