List all permission on server role and database role on sql server 2014

%3CLINGO-SUB%20id%3D%22lingo-sub-1055150%22%20slang%3D%22en-US%22%3EList%20all%20permission%20on%20server%20role%20and%20database%20role%20on%20sql%20server%202014%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055150%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20On%20our%20organization%20%2C%20we%20are%20on%20the%20way%20to%20apply%20SoD%20(Segregation%20of%20duties)%20between%20system%20and%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Bsecurity%20admins%20so%20we%20want%20to%20list%20all%20permission%20on%20server%20role%20and%20database%20role%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehints%3C%2FP%3E%3CP%3E1-%20We%20know%20that%20that%20there%20is%26nbsp%3B%20security%20admin%20role%3C%2FP%3E%3CP%3E2-%20I%20googled%20about%20to%26nbsp%3Blist%20all%20permission%20on%20server%20role%20and%20database%20role%20but%20with%20no%20luck%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20Advance%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1055150%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Esql%20server%202014%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello All, 

  On our organization , we are on the way to apply SoD (Segregation of duties) between system and     security admins so we want to list all permission on server role and database role

 

hints

1- We know that that there is  security admin role

2- I googled about to list all permission on server role and database role but with no luck 

 

Thanks in Advance 

 

 

 

0 Replies