This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I've assigned resource_class to a specific Active Directory group, but the user within that group gets the default resource_class assigned when executing queries.
User X is assigned to AD group Y.
Y is assigned to 'mediumrc' but the execution request of X get the default resource_class 'smallrc'.
Do we need to execute sp_addrolemember per user or should it be possible to add an AD group?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Hi @XchangeVisions ,
Thanks for your query and using this forum.
I have reached out to internal team to double confirm on this requirement. I will keep you posted as soon as I have a response from the team.
We appreciate your patience.
Thank you
User is assigned to the AAD Admin usergroup.
Added the 'dbo' role to the classifier and now it's assigned the expected resource class.
Hi @XchangeVisions ,
Glad to know that the given suggestion was helpful to resolve your issue. Thanks much for confirming.
Hi @XchangeVisions ,
Update: It is likely the user or group is part of the AAD admin which by default is routed to smallrc. Could you please creating a workload classifier on the ‘dbo’ role to mediumrc and that should address the situation.
Please let us know how it goes.
Thank you
Hi @KranthiPakala-MSFT ,
Thank you for the response.
You are right that the user belongs to the group that is assigned AAD admin.
I ended up removing the 'resource class role mappings' and instead configured 'workload groups'.
I've assigned the 'dbo' role as member of a classifier assigned to a workload group, and now I can see that the user is getting the correct workload group (resource class) assigned.
Thank you