Clone login and apply permissions

clone_login_permissions.ps1

Param (
  $SourceServer,
  $TargetServer,
  $Login
)
$loginObject = Get-DbaLogin -SqlInstance $SourceServer -Login $Login
Copy-DbaLogin -Destination $TargetServer -Login $loginObject

foreach ($dbName in $login.EnumDatabaseMappings()) {
  $db = Get-DbaDatabase -SqlInstance $SourceServer -Database $dbName
  foreach ($user in ($db.Users | Where-Object Login -eq $loginObject.Name)) {
    $permissions = Export-DbaUser -SqlInstance $SourceServer -Database $db -User $user
    Invoke-DbaQuery -SqlInstance $TargetServer -Database $db -Query $permissions
  }
}