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

  roles = [
    "rds_superuser",
    "main_owner",
  ]
}

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

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

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


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

  roles = [
    "main_reader",
    "aggregates_reader",
  ]
}

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

  roles = [
    "main_reader",
    "aggregates_reader",
  ]
}