Thanks for everyones responses.

As someone above pointed out, the option of using a recursive function has a limit of 32, so that is ruled out.  And since we wouldn't want to...

Thanks for your response.

Unfortuantely we do not know the level of nesting, we limit it to 100 but it is not fixed.

We use one table for Users and Roles because...