resource "mysql_grant" "apollo_utph_usr_all_db_all_tables" {
  database = "*"
  user     = mysql_user.apollo_utph_usr.user
  host     = mysql_user.apollo_utph_usr.host
  table    = "*"
  privileges = [
    "SELECT", "INSERT", "UPDATE", "DELETE", "CREATE", "DROP", "INDEX", "ALTER",
    "SHOW DATABASES", "CREATE TEMPORARY TABLES", "LOCK TABLES", "CREATE VIEW",
    "SHOW VIEW", "CREATE ROUTINE", "ALTER ROUTINE", "EVENT",
    "TRIGGER", "LOAD FROM S3", "SELECT INTO S3",
  ]
}

resource "mysql_grant" "dataart_ro_dbSony_dbo" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.dataart_ro.user
  host     = mysql_user.dataart_ro.host
  privileges = [
    "SELECT",
  ]
}

resource "mysql_grant" "delphi_ro_all_db_all_tables" {
  database = "*"
  user     = mysql_user.delphi_ro.user
  host     = mysql_user.delphi_ro.host
  table    = "*"
  privileges = [
    "SELECT INTO S3",
  ]
}

resource "mysql_grant" "delphi_ro_dbSony_dbo" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.delphi_ro.user
  host     = mysql_user.delphi_ro.host
  privileges = [
    "SELECT",
    "SHOW VIEW",
  ]
}

resource "mysql_grant" "fivetran_all_db_all_tables" {
  database = "*"
  user     = mysql_user.fivetran.user
  host     = mysql_user.fivetran.host
  privileges = [
    "RELOAD", "LOCK TABLES", "EXECUTE",
    "REPLICATION SLAVE", "REPLICATION CLIENT",
  ]
}

resource "mysql_grant" "fivetran_dbSony_dbo_tblAppleMusicAlbum" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.fivetran.user
  host     = mysql_user.fivetran.host
  table    = "tblAppleMusicAlbum"
  privileges = [
    "SELECT",
  ]
}

resource "mysql_grant" "fivetran_dbSony_dbo_tblSpotifyTrack2" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.fivetran.user
  host     = mysql_user.fivetran.host
  table    = "tblSpotifyTrack2"
  privileges = [
    "SELECT",
  ]
}

resource "mysql_grant" "fivetran_dbSony_dbo_tblSpotifyPlaylistTrackList" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.fivetran.user
  host     = mysql_user.fivetran.host
  table    = "tblSpotifyPlaylistTrackList"
  privileges = [
    "SELECT",
  ]
}

resource "mysql_grant" "fivetran_dbSony_dbo_tblSpotifyPlaylist" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.fivetran.user
  host     = mysql_user.fivetran.host
  table    = "tblSpotifyPlaylist"
  privileges = [
    "SELECT",
  ]
}

resource "mysql_grant" "fivetran_dbSony_dbo_BuzzUser" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.fivetran.user
  host     = mysql_user.fivetran.host
  table    = "BuzzUser"
  privileges = [
    "SELECT",
  ]
}

resource "mysql_grant" "fivetran_dbSony_dbo_tblSpotifyPlaylistTrackList2" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.fivetran.user
  host     = mysql_user.fivetran.host
  table    = "tblSpotifyPlaylistTrackList2"
  privileges = [
    "SELECT",
  ]
}

resource "mysql_grant" "fivetran_dbSony_dbo_tblAppleMusicPlaylistTracklist" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.fivetran.user
  host     = mysql_user.fivetran.host
  table    = "tblAppleMusicPlaylistTracklist"
  privileges = [
    "SELECT",
  ]
}

resource "mysql_grant" "fivetran_dbSony_dbo_BuzzCategory" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.fivetran.user
  host     = mysql_user.fivetran.host
  table    = "BuzzCategory"
  privileges = [
    "SELECT",
  ]
}

resource "mysql_grant" "fivetran_dbSony_dbo_tblSpotifyAlbum" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.fivetran.user
  host     = mysql_user.fivetran.host
  table    = "tblSpotifyAlbum"
  privileges = [
    "SELECT",
  ]
}

resource "mysql_grant" "fivetran_dbSony_dbo_tblSpotifyPlaylistTrackListHistory2" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.fivetran.user
  host     = mysql_user.fivetran.host
  table    = "tblSpotifyPlaylistTrackListHistory2"
  privileges = [
    "SELECT",
  ]
}

resource "mysql_grant" "fivetran_dbSony_dbo_tblAppleMusicSong" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.fivetran.user
  host     = mysql_user.fivetran.host
  table    = "tblAppleMusicSong"
  privileges = [
    "SELECT",
  ]
}

resource "mysql_grant" "fivetran_dbSony_dbo_tblSpotifyTrackAlbum" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.fivetran.user
  host     = mysql_user.fivetran.host
  table    = "tblSpotifyTrackAlbum"
  privileges = [
    "SELECT",
  ]
}

resource "mysql_grant" "fivetran_dbSony_dbo_tblSpotifyPlaylistFollowerHistory" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.fivetran.user
  host     = mysql_user.fivetran.host
  table    = "tblSpotifyPlaylistFollowerHistory"
  privileges = [
    "SELECT",
  ]
}

resource "mysql_grant" "fivetran_dbSony_dbo_tblMusicService" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.fivetran.user
  host     = mysql_user.fivetran.host
  table    = "tblMusicService"
  privileges = [
    "SELECT",
  ]
}

resource "mysql_grant" "fivetran_dbSony_dbo_tblSpotifyPlaylistFollowers" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.fivetran.user
  host     = mysql_user.fivetran.host
  table    = "tblSpotifyPlaylistFollowers"
  privileges = [
    "SELECT",
  ]
}

resource "mysql_grant" "fivetran_dbSony_dbo_tblAppleMusicSongArtist" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.fivetran.user
  host     = mysql_user.fivetran.host
  table    = "tblAppleMusicSongArtist"
  privileges = [
    "SELECT",
  ]
}

resource "mysql_grant" "fivetran_dbSony_dbo_tblAppleMusicPlaylist" {
  database = mysql_database.dbSony_dbo.name
  user     = mysql_user.fivetran.user
  host     = mysql_user.fivetran.host
  table    = "tblAppleMusicPlaylist"
  privileges = [
    "SELECT",
  ]
}

resource "mysql_grant" "apollo_etl_all_db_all_tables" {
  database = "*"
  user     = mysql_user.apollo_etl.user
  host     = mysql_user.apollo_etl.host
  table    = "*"
  privileges = [
    "SELECT", "INSERT", "UPDATE", "DELETE", "CREATE", "DROP", "RELOAD",
    "PROCESS", "REFERENCES", "INDEX", "ALTER", "SHOW DATABASES",
    "CREATE TEMPORARY TABLES", "LOCK TABLES", "EXECUTE", "CREATE VIEW",
    "SHOW VIEW", "CREATE ROUTINE", "ALTER ROUTINE", "EVENT", "TRIGGER",
    "LOAD FROM S3", "SELECT INTO S3", "INVOKE LAMBDA",
  ]
}

resource "mysql_grant" "apollo_api_all_db_all_tables" {
  database = "*"
  user     = mysql_user.apollo_api.user
  host     = mysql_user.apollo_api.host
  table    = "*"
  privileges = [
    "SELECT", "INSERT", "UPDATE", "DELETE", "CREATE", "DROP", "RELOAD",
    "PROCESS", "REFERENCES", "INDEX", "ALTER", "SHOW DATABASES",
    "CREATE TEMPORARY TABLES", "LOCK TABLES", "EXECUTE", "CREATE VIEW",
    "SHOW VIEW", "CREATE ROUTINE", "ALTER ROUTINE", "EVENT", "TRIGGER",
    "LOAD FROM S3", "SELECT INTO S3", "INVOKE LAMBDA",
  ]
}