locals {
  view_read_privileges = toset(["REFERENCES", "SELECT"])
}

module "role" {
  source           = "../../../internal/objects_access_database_role"
  database_name    = var.database
  role_name_suffix = "${var.schema}_SCHEMA_${var.view}_VIEW_READ"

  schema_objects_by_type_and_privileges = [
    {
      schema     = var.schema,
      type       = "view",
      objects    = [var.view],
      privileges = local.view_read_privileges,
    },
  ]
}