Home Forums SQL Server 7,2000 Sarbanes-Oxley How to identify GROUPS in database roles RE: How to identify GROUPS in database roles
Prasad Pavirala
SSC-Addicted
Points: 491
More actions
April 6, 2006 at 9:03 am
#631254
Nevermind. I got it.
I am now using sp_helpuser, so that I can get both database user and login.
After that I can use isntgroup column in sysusers table to find which one of these account are actually groups.
Thanks!