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

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

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

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

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

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

  roles = [
    postgresql_role.user_data_reader.name
  ]
}