I have following hierarchy in distribution groups in windows
A,B, C are distribution groups in Windows , each with set of windows users
Group A is a part of Group B which in turn is part of Group C
C has been converted to a security group
I have mapped group C to a sql role and given the role appropriate permissions
My question is since distribution group A and B are part of group C , wouldnt
users in group A and B have the same rights as group C.
Though users in group C are able to connect with those permissions, users in group A and B are not able to inherit those rights.
What could be the possible solution to this issue?