how to figure out if there are any identical roles

Hi All,

I have kind of a tricky question that I cannot find a solution for.

My goal is to write a SQL or query that tells me if there are any roles that have the identical permission lists.

for example:

role A  has permission lists A, B, C, and D

role B  has permission lists A, C, and D

role C has permission list B and C

role D has permission lists A, B, C, and D

My goal would be to identify that roles A and D are identical, and have the identical permission lists.

Any ideas are appreciated!