Database and Warehouse Permissions Overwritten

[vjoshi-89]

Hi,

I'm trying to grant multiple roles privileges to one database but each time I check the plan the last privilege overwrites the first privilege.

Below is an example of the code I'm running

locals {
  database_grants = {
    "ANALYTICS" = {
      privilege = ["MODIFY",]
      roles = ["RL_ANALYST", "RL_BI", "RL_LOADER", "RL_SUPPORT"]
    "ANALYTICS" = {
      privilege = "USAGE"
      roles = ["RL_ANALYST", "RL_BI", "RL_LOADER" ]
    }
  }
}

resource "snowflake_database_grant" "database_grants" {
  depends_on = [snowflake_role.role]
  for_each = local.database_grants
  database_name = each.key
  privilege  = each.value.privilege
  roles = each.value.roles
  with_grant_option = true
}

The output I get when planning is the following

  # snowflake_database_grant.database_grants["ANALYTICS2"] will be created
  + resource "snowflake_database_grant" "database_grants" {
      + database_name     = "ANALYTICS"
      + id                = (known after apply)
      + privilege         = "USAGE"
      + roles             = [
          + "RL_ANALYST",
          + "RL_BI",
          + "RL_LOADER",
        ]
      + with_grant_option = true
    }

Hope someone could help me understand what I'm doing wrong as I'm having the same problem when granting the warehouse different role based privileges and using the same template as above.