SQL Server Performance Forum – Threads Archive
system wide and database wide role per userHi there, How do I find what are the system wide and database wide roles assigned for each user ? ‘sp_helprotect’ gives me all the permissions in all the user objects. But I am keen to know only the system wide and database wide roles granted for each and every login. Thank you.
sp_helprolemember and sp_helpsrvrolemember are probably what you’re after Cheers
Thank you Twan