---
title: 'Ресурс selectel_dbaas_grant_v1'
sidebar_label: "selectel_dbaas_grant_v1"
description: 'Grants privileges to the users in Selectel Managed Databases using public API v1'
sidebar_position: 4
---

# Ресурс selectel\_dbaas\_grant\_v1

:::info

Эта инструкция — копия документации Selectel Terraform-провайдера в [Terraform Registry](https://registry.terraform.io/providers/selectel/selectel/latest/docs).

:::

Grants privileges to the users in Managed Databases using public API v1. Not applicable to Redis and Kafka. Learn more about Managed Databases in the [official Selectel documentation](/managed-databases/).

## Example usage \{#example-usage}

### PostgreSQL, PostgreSQL for 1C, and PostgreSQL TimescaleDB \{#postgresql-postgresql-for-1c-and-postgresql-timescaledb}

```hcl
resource "selectel_dbaas_grant_v1" "grant_1" {
  project_id   = selectel_vpc_project_v2.project_1.id
  region       = "ru-3"
  datastore_id = selectel_dbaas_postgresql_datastore_v1.cluster_1.id
  database_id  = selectel_dbaas_postgresql_database_v1.database_1.id
  user_id      = selectel_dbaas_user_v1.user_1.id
}
```

### MySQL semi-sync and MySQL sync \{#mysql-semi-sync-and-mysql-sync}

```hcl
resource "selectel_dbaas_grant_v1" "grant_1" {
  project_id   = selectel_vpc_project_v2.project_1.id
  region       = "ru-3"
  datastore_id = selectel_dbaas_mysql_datastore_v1.cluster_1.id
  database_id  = selectel_dbaas_mysql_database_v1.database_1.id
  user_id      = selectel_dbaas_user_v1.user_1.id
}
```

## Argument Reference \{#argument-reference}

* `project_id` - (Required) Unique identifier of the associated project. Changing this creates a new privilege for the user. Retrieved from the [selectel\_vpc\_project\_v2](/terraform/selectel-provider-reference/resources/vpc_project_v2) resource. Learn more about [Projects](/access-control/projects/about-projects/).

* `region` - (Required) Pool where the database is located, for example, `ru-3`. Changing this creates a new privilege for the user.

* `datastore_id` - (Required) Unique identifier of the associated cluster. Changing this creates a new privilege for the user. Retrieved from the [selectel\_dbaas\_postgresql\_datastore\_v1](/terraform/selectel-provider-reference/resources/dbaas_postgresql_datastore_v1) or [selectel\_dbaas\_mysql\_datastore\_v1](/terraform/selectel-provider-reference/resources/dbaas_mysql_datastore_v1) resource depending on the cluster type you use.

* `database_id` - (Required) Unique identifier of the associated database. Changing this creates a new privilege for the user. Retrieved from the [selectel\_dbaas\_postgresql\_database\_v1](/terraform/selectel-provider-reference/resources/dbaas_postgresql_database_v1) or [selectel\_dbaas\_mysql\_database\_v1](/terraform/selectel-provider-reference/resources/dbaas_mysql_database_v1) resource depending on the cluster type you use.

* `user_id` - (Required) Unique identifier of the associated user. Changing this creates a new privilege for the user. Retrieved from the [selectel\_dbaas\_user\_v1](/terraform/selectel-provider-reference/resources/dbaas_user_v1) resource.

## Attributes Reference \{#attributes-reference}

* `status` - Status of the user privilege.