> For the complete documentation index, see [llms.txt](https://docs.starrocks.io/llms.txt). This page is also available as Markdown at its `.md` URL.

# ALTER RESOURCE GROUP

ALTER RESOURCE GROUP alters the configuration of a resource group.

tip

This operation requires the ALTER privilege on the target resource group. You can follow the instructions in [GRANT](https://docs.starrocks.io/docs/sql-reference/sql-statements/account-management/GRANT.md) to grant this privilege.

## Syntax[​](#syntax "Direct link to Syntax")

```sql
ALTER RESOURCE GROUP resource_group_name
{  ADD CLASSIFIER1, CLASSIFIER2, ...
 | DROP (CLASSIFIER_ID_1, CLASSIFIER_ID_2, ...)
 | DROP ALL
 | WITH resource_limit 
};

```

## Parameters[​](#parameters "Direct link to Parameters")

| **Parameter**         | **Description**                                                                                                                                                                                                                                                        |
| --------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| resource_group_name | Name of the resource group to be altered.                                                                                                                                                                                                                              |
| ADD                   | Add classifiers to the resource group. See [CREATE RESOURCE GROUP - Parameters](https://docs.starrocks.io/docs/sql-reference/sql-statements/cluster-management/resource_group/CREATE_RESOURCE_GROUP.md) for more information on how to define a classifier.            |
| DROP                  | Drop classifiers from the resource group via classifier IDs. You can check the ID of a classifier via [SHOW RESOURCE GROUP](https://docs.starrocks.io/docs/sql-reference/sql-statements/cluster-management/resource_group/SHOW_RESOURCE_GROUP.md) statement.           |
| DROP ALL              | Drop all classifiers from the resource group.                                                                                                                                                                                                                          |
| WITH                  | Modify the resource limits of the resource group. See [CREATE RESOURCE GROUP - Parameters](https://docs.starrocks.io/docs/sql-reference/sql-statements/cluster-management/resource_group/CREATE_RESOURCE_GROUP.md) for more information on how to set resource limits. |

## Examples[​](#examples "Direct link to Examples")

Example 1: Adds a new classifier to the resource group `rg1`.

```sql
ALTER RESOURCE GROUP rg1 ADD (user='root', query_type in ('select'));

```

Example 2: Drops classifiers with ID `300040`, `300041`, and `300041` from the resource group `rg1`.

```sql
ALTER RESOURCE GROUP rg1 DROP (300040, 300041, 300041);

```

Example 3: Drops all classifiers from the resource group `rg1`.

```sql
ALTER RESOURCE GROUP rg1 DROP ALL;

```

Example 4: modifies the resource limits of the resource group `rg1`.

```sql
ALTER RESOURCE GROUP rg1 WITH (
    'cpu_weight' = '10'
);

```