ALTER ROLE - Kinetica Docs

A role can have its associated resource group modified.

ALTER ROLE Syntax

ALTER ROLE <role name>
SET RESOURCE GROUP [=] <group name | DEFAULT>

Examples

To assign the memory_over_execution resource group to the analyst role:

ALTER ROLE Example

ALTER ROLE analyst
SET RESOURCE GROUP memory_over_execution

To unassign the resource group from the analyst role:

ALTER ROLE Removing Resource Group Example

ALTER ROLE analyst
SET RESOURCE GROUP DEFAULT