resource "postgresql_grant" "main_user_api_decibel_schema_ro" {
  database    = postgresql_database.main.name
  role        = "main_user_api"
  schema      = postgresql_schema.decibel_schema.name
  object_type = "schema"
  privileges  = ["USAGE"]
}

resource "postgresql_grant" "main_user_api_decibel_table_ro" {
  database    = postgresql_database.main.name
  role        = "main_user_api"
  schema      = postgresql_schema.decibel_schema.name
  object_type = "table"
  privileges  = ["SELECT"]
}

resource "postgresql_grant" "main_user_decibel_schema_ro" {
  database    = postgresql_database.main.name
  role        = "main_user"
  schema      = postgresql_schema.decibel_schema.name
  object_type = "schema"
  privileges  = ["USAGE"]
}

resource "postgresql_grant" "main_user_decibel_table_ro" {
  database    = postgresql_database.main.name
  role        = "main_user"
  schema      = postgresql_schema.decibel_schema.name
  object_type = "table"
  privileges  = ["SELECT"]
}