Cannot create scaleway_rdb_privilege resource

[gmile]

Terraform Version

$ terraform version
Terraform v1.11.1
on darwin_arm64

Affected Resource(s)

• scaleway_rdb_privilege

Terraform Configuration Files

Create database and user:

resource "random_pet" "db_master_name" {
  length = 2
  prefix = var.environment
}

resource "random_password" "db_master_password" {
  length = 32
}

resource "scaleway_rdb_database" "api" {
  instance_id = scaleway_rdb_instance.instance_v2.id
  name        = var.environment
}

resource "scaleway_rdb_user" "api" {
  instance_id = scaleway_rdb_instance.instance_v2.id
  name        = "${var.environment}-user"
  password    = random_password.db_password.result
}

resource "scaleway_rdb_instance" "instance_v2" {
  name           = random_pet.db_master_name.id
  node_type      = "db-dev-m"
  engine         = "PostgreSQL-16"
  user_name      = "master_user"
  password       = random_password.db_master_password.result
  volume_type    = "bssd"
}

# resource "scaleway_rdb_privilege" "api" {
#  instance_id   = scaleway_rdb_instance.instance_v2.id
#  user_name     = scaleway_rdb_user.api.name
#  database_name = scaleway_rdb_database.api.name
#  permission    = "all"
# }

Expected Behavior

A privilege is created.

Actual Behavior

A privilege is not created. Instead, and error is printed:

scaleway_rdb_privilege.api: Creating...
╷
│ Error: scaleway-sdk-go: invalid argument(s): database_name does not respect constraint, This database is not managed by RDB service, you can not change permission with the API. Use CLI instead
│
│   with scaleway_rdb_privilege.api,
│   on ../sources/database.tf line 71, in resource "scaleway_rdb_privilege" "api":
│   71: resource "scaleway_rdb_privilege" "api" {
│
╵

Steps to Reproduce

1. create all resources (instance, database, user) except scaleway_rdb_privilege,
2. once all resources (instance, database, user) are created, uncomment scaleway_rdb_privilege and attempt to create it

References

• Crash on RDB permissions #1140 (comment) - closest I could find to the issue I'm observing - that comment contains an error message similar to mine

Important Factoids

In a real-world scenario the DB instance & users were imported into terraform (e.g. not created from scratch in terraform).

[gmile]

The users originally were provisioned using psql - could that be related, or straight up the reason I am getting the error? If so, then would I be able to import such users into scaleway_rdb_user resource 🤔