# ALTER SERVICE ACCOUNT SET RESOURCE GROUP reference

> **For AI agents:** the complete documentation index is at [llms.txt](https://questdb.com/docs/llms.txt). Every page is available as markdown by appending `.md` to its URL, or by sending an `Accept: text/markdown` request header.

ALTER SERVICE ACCOUNT SET RESOURCE GROUP places a service account's queries under a resource group. Applies to QuestDB Enterprise.

<EnterpriseNote>
  Resource groups isolate competing query workloads inside a single QuestDB
  instance.
</EnterpriseNote>

`ALTER SERVICE ACCOUNT ... SET RESOURCE GROUP` places the service account's
queries under a [resource group](/docs/concepts/resource-groups/), which governs
their admission, CPU share and memory budget.

---

## Syntax

```questdb-sql
ALTER SERVICE ACCOUNT serviceAccountName SET RESOURCE GROUP resourceGroupName;
```

## Description

A session that assumes the service account keeps the resource group of the
principal that logged in. The account's own mapping applies to sessions that
authenticate as it.

`MAPPING PRIORITY` is **not** accepted here, because a service account has
exactly one mapping and there is nothing to break a tie between. It belongs to
[`ALTER GROUP SET RESOURCE GROUP`](/docs/query/sql/acl/alter-group-set-resource-group/).

The statement requires the
[`RESOURCE GROUP ADMIN`](/docs/security/rbac/#permissions) permission, and affects
queries that start after the change rather than one already running.

The mapping decides the group the account's sessions start in. A session can
still run its queries in another group with
[`SET RESOURCE GROUP`](/docs/query/sql/acl/set-resource-group/), or an HTTP
request with the `resource_group` parameter, if the account holds
`USE RESOURCE GROUP` on it. The mapped group needs no such grant.

This governs the queries the account runs. It does not throttle ingestion, which
resource groups do not manage.

## Examples

```questdb-sql
ALTER SERVICE ACCOUNT client_app SET RESOURCE GROUP automation;
```

Verify with
[`SHOW SERVICE ACCOUNTS`](/docs/query/sql/show/#show-service-accounts), which
reports the mapping in its `resource_group` column:

```questdb-sql
SELECT name, resource_group FROM (SHOW SERVICE ACCOUNTS);
```

| name       | resource_group |
| ---------- | -------------- |
| client_app | automation     |

## See also

- [ALTER SERVICE ACCOUNT UNSET RESOURCE GROUP](/docs/query/sql/acl/alter-service-account-unset-resource-group/)
- [CREATE RESOURCE GROUP](/docs/query/sql/acl/create-resource-group/)
- [Resource groups](/docs/concepts/resource-groups/)