SQL Server Performance Forum – Threads Archive

system wide and database wide role per user

Hi 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
Twan

---

Thank you Twan

---

]]>