ALTER USER UNSET RESOURCE GROUP reference
Resource groups isolate competing query workloads inside a single QuestDB instance.
ALTER USER ... UNSET RESOURCE GROUP removes the user's direct
resource group mapping.
Syntax
ALTER USER userName UNSET RESOURCE GROUP;
Description
Removing the direct mapping does not leave the user ungoverned. Its queries fall
back to the highest-priority mapping among its ACL groups, or to DEFAULT when
it belongs to none that are mapped.
The statement requires the
RESOURCE GROUP ADMIN permission, and affects
queries that start after the change rather than one already running.
Unmapping is also the prerequisite for dropping a resource group:
DROP RESOURCE GROUP is refused
while any principal is still mapped to it.
Examples
ALTER USER john UNSET RESOURCE GROUP;
SHOW USERS then reports null in the resource_group column:
SELECT name, resource_group FROM (SHOW USERS);
| name | resource_group |
|---|---|
| admin | null |
| john | null |
null means no direct mapping, not that the user is ungoverned. Use
current_resource_group()
from the user's own session to see the group its queries actually resolve to.