Home Forums SQL Server 2008 SQL Server 2008 Administration Script to get the list of users and permissions in a database RE: Script to get the list of users and permissions in a database
george sibbald
SSC Guru
Points: 104210
More actions
April 10, 2014 at 9:19 am
#1704947
if you just want database roles users have granted use sp_helprolemember.
This could be put in a cursor which loops through all your databases
---------------------------------------------------------------------