resource "postgresql_role" "main_admin" {
  name            = "main_admin"
  create_database = true
  create_role     = true
  login           = true

  roles = [
    postgresql_role.main_owner.name,
    "rds_superuser",
  ]
}

resource "postgresql_role" "main_owner" {
  name            = "main_owner"
  create_database = true
  create_role     = false
  login           = true

  roles = [
    "main_user_gras_apps_etl",
    postgresql_role.main_user.name,
  ]
}

resource "postgresql_role" "main_reader" {
  name  = "main_reader"
  login = true
}

resource "postgresql_role" "main_reader_iam" {
  name  = "main_reader_iam"
  login = true

  roles = [
    postgresql_role.main_reader.name,
    "rds_iam",
  ]
}

resource "postgresql_role" "main_user" {
  name  = "main_user"
  login = true
}

resource "postgresql_role" "main_user_iam" {
  name  = "main_user_iam"
  login = true

  roles = [
    postgresql_role.main_user.name,
    "rds_iam",
  ]
}

resource "postgresql_role" "rpashchenko" {
  name  = "rpashchenko"
  login = true

  roles = [
    postgresql_role.main_owner.name,
    postgresql_role.main_user.name,
    "main_user_gras_apps_etl",
  ]
}

resource "postgresql_role" "slaposhko" {
  name  = "slaposhko"
  login = true

  roles = [
    postgresql_role.main_owner.name,
  ]
}