Accepted AnswerModeratorBrian AmosOffline
Accepted AnswerPaul ThompsonOffline0I have a bit of SQL that generates various User, Group and Role lists. It is specific to MS SQL Server due to the use of "for XML PATH". If you're running Oracle you might be able to modify it.
I'm NOT a DB admin so it's definitely not optimal (I'm being overly generous with myself). I had started work on dumping privileges but needed to move on to other tasks so that part is unfinished.