Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if (![System.String]::IsNullOrWhiteSpace($JsonData))
- {
- foreach ($dbCred in $dbCreds)
- {
- $LoginName = $dbCred.LoginName
- $LoginPassword = $dbCred.Password
- $LoginRoles = $dbCred.LoginRoles
- $UserName = $dbCred.UserName
- $UserRoles = $dbCred.UserRoles
- Write-Log "Database Credentials for UserName: $UserName, LoginName: $LoginName, UserRoles: $UserRoles, LoginRoles: $LoginRoles"
- #$Sql.Refresh()
- #Create-SqlServerLogin $targetServerName $targetDatabaseName $LoginName $UserName $LoginPassword $LoginRoles
- #Create-DatabaseUser $targetServerName $targetDatabaseName $LoginName $UserName $UserRoles
- CreateUserWithPassword $target_sqlParams $LoginName $LoginPassword
- foreach($role in $UserRoles)
- {
- AddUserToRole $target_sqlParams $LoginName $role
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement