[Yandex Cloud documentation](../../index.md) > [Terraform in Yandex Cloud](../index.md) > Terraform reference > Resources > Managed Service for SPQR > Resources > mdb_sharded_postgresql_user

# yandex_mdb_sharded_postgresql_user (Resource)

Manages a Sharded PostgreSQL user within the Yandex.Cloud

## Example usage

```terraform
//
// Create a new MDB Sharded PostgreSQL database User.
//
resource "yandex_mdb_sharded_postgresql_user" "my_user" {
  cluster_id = yandex_mdb_sharded_postgresql_cluster.my_user.id
  name       = "alice"
  password   = "password"
  settings = {
    connection_limit = 300
    connection_retries = 5
  }
}

resource "yandex_mdb_sharded_postgresql_cluster" "default" {
  name        = "test"
  environment = "PRESTABLE"
  network_id  = yandex_vpc_network.foo.id

  config = {
    sharded_postgresql_config = {
      common = {
        console_password = "P@ssw0rd"
      }
      router = {
        resources = {
          resource_preset_id = "s2.micro"
          disk_type_id       = "network-ssd"
          disk_size          = 32
        }
      }
    }
  }

  hosts = {
    "router1" = {
      zone      = "ru-central1-a"
      subnet_id = yandex_vpc_subnet.foo.id
      assign_public_ip = false
      type = "ROUTER"
    }
  }
}

// Auxiliary resources
resource "yandex_vpc_network" "foo" {}

resource "yandex_vpc_subnet" "foo" {
  zone           = "ru-central1-d"
  network_id     = yandex_vpc_network.foo.id
  v4_cidr_blocks = ["10.5.0.0/24"]
}
```

## Arguments & Attributes Reference

- `cluster_id` (**Required**)(String). ID of the Sharded PostgreSQL cluster. Provided by the client when the user is created.
- `grants` (Set Of String). 
- `id` (*Read-Only*) (String). The resource identifier.
- `name` (**Required**)(String). Name of the Sharded PostgreSQL user. Provided by the client when the user is created.
- `password` (String). Password of the Sharded PostgreSQL user. Provided by the client when the user is created.
- `settings` (Map Of String). 
- `timeouts` [Block]. 
  - `create` (String). A string that can be [parsed as a duration](https://pkg.go.dev/time#ParseDuration) consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
  - `delete` (String). A string that can be [parsed as a duration](https://pkg.go.dev/time#ParseDuration) consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
  - `update` (String). A string that can be [parsed as a duration](https://pkg.go.dev/time#ParseDuration) consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
- `permissions` [Block]. Block represents databases that are permitted to user.
  - `database` (**Required**)(String). Name of the database that the permission grants access to.

## Import

The resource can be imported by using their `resource ID`. For getting it you can use Yandex Cloud [Web Console](https://console.yandex.cloud) or Yandex Cloud [CLI](../../cli/quickstart.md).

```shell
# terraform import yandex_mdb_sharded_postgresql_user.<resource Name> <resource Id>
terraform import yandex_mdb_sharded_postgresql_user.my_user ...
```