locals {
  streamlit_read_privileges = toset(["USAGE"])
}

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

  schema_objects_by_type_and_privileges = [
    {
      schema     = var.schema,
      type       = "streamlit",
      objects    = [var.streamlit_id],
      privileges = local.streamlit_read_privileges,
    },
  ]
}