How to handle the multiple databases and its schema related accesses in a redshift cluster using the provider

[rajasekaranmpomelo]

When we have two databases are configured in a cluster and with different schema's are created on the databases, How can we grant privileges for different schema's on different databases. In the below example, if the raw schema is in one database and staging schema is on another database and our terraform point the 1st database, does the below second resource can identify the staging schema in 2nd database and assigns the necessary privileges?

resource "redshift_default_privileges" "de_raw_transform" {
group = "transform"
owner = "dataeng"
schema = "raw"
object_type = "table"
privileges = ["select"]
}

resource "redshift_default_privileges" "de_staging_transform" {
group = "transform"
owner = "dataengg"
schema = "staging"
object_type = "table"
privileges = ["select"]
}

[jimmymaise]

i think we may need to add multiple providers

[hazmei]

Facing the same issue on our end as well. Unfortunately, adding multiple providers is not an option as our terraform code dynamically create new database and would then add the default privileges in the db.