Resource Pool for a group of users

Help
1

Hi team! I have a question about resource pool.
How to assign a resource pool to a group? I’ve attempted to assign a role to a group and then assign a resource pool to that role using the following command:

grant usage on resource pool pool_1 to role ‘role_1’;

Afterwards, I checked the default resource pool of the users in the group and found that it was still ‘default_pool’.
Is there a way for me to assign a default pool to a group and use dynamic resource pool selection based on user group?
Thank you in advance!

2

No, we can’t have resource pools at group level.

3

Hi,
you can implement a Resource Pool Selector Function. See:

Maybe you can implement what you need by using this and CURRENT_SECURITY_GROUPS · SingleStore Documentation