Advertisement
Guest User

Untitled

a guest
May 7th, 2018
702
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. if (![System.String]::IsNullOrWhiteSpace($JsonData))
  2. {
  3. foreach ($dbCred in $dbCreds)
  4. {
  5. $LoginName = $dbCred.LoginName
  6. $LoginPassword = $dbCred.Password
  7. $LoginRoles = $dbCred.LoginRoles
  8. $UserName = $dbCred.UserName
  9. $UserRoles = $dbCred.UserRoles
  10.  
  11. Write-Log "Database Credentials for UserName: $UserName, LoginName: $LoginName, UserRoles: $UserRoles, LoginRoles: $LoginRoles"
  12.  
  13. #$Sql.Refresh()
  14. #Create-SqlServerLogin $targetServerName $targetDatabaseName $LoginName $UserName $LoginPassword $LoginRoles
  15. #Create-DatabaseUser $targetServerName $targetDatabaseName $LoginName $UserName $UserRoles
  16. CreateUserWithPassword $target_sqlParams $LoginName $LoginPassword
  17. foreach($role in $UserRoles)
  18. {
  19. AddUserToRole $target_sqlParams $LoginName $role
  20. }
  21. }
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement