## 26.3.26 The INFORMATION_SCHEMA RESOURCE_GROUPS Table 

The RESOURCE_GROUPS  table provides access to information about resource groups. For general discussion of the resource group capability, see Section 5.1.16, “Resource Groups” . 

You can see information only for columns for which you have some privilege. 

The RESOURCE_GROUPS  table has these columns: 

• RESOURCE_GROUP_NAME 

The name of the resource group. 

• RESOURCE_GROUP_TYPE 

The resource group type, either SYSTEM  or USER . 

• RESOURCE_GROUP_ENABLED 

Whether the resource group is enabled (1) or disabled (0); 

• VCPU_IDS 

The CPU affinity; that is, the set of virtual CPUs that the resource group can use. The value is a list of comma-separated CPU numbers or ranges. 

• THREAD_PRIORITY 

The priority for threads assigned to the resource group. The priority ranges from -20 (highest priority) to 19 (lowest priority). System resource groups have a priority that ranges from -20 to 0. User resource groups have a priority that ranges from 0 to 19. 

## 26.3.27 The INFORMATION_SCHEMA ROLE_COLUMN_GRANTS Table 

The ROLE_COLUMN_GRANTS  table (available as of MySQL 8.0.19) provides information about the column privileges for roles that are available to or granted by the currently enabled roles. 

The ROLE_COLUMN_GRANTS  table has these columns: 

• GRANTOR 

The user name part of the account that granted the role. 

• GRANTOR_HOST 

The host name part of the account that granted the role. 

• GRANTEE 

The user name part of the account to which the role is granted. 

• GRANTEE_HOST 

The host name part of the account to which the role is granted. 

• TABLE_CATALOG 

The name of the catalog to which the role applies. This value is always def . 

