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

Copper Contributor

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