data-konzept

'Quite a while ago I created a couple of little security scripts to help me out with permissions research. Over time they grew into the procedures sp_dbpermissions and sp_srvpermissions. I recently updated them to v 6.0 and one of the main reasons was so I could add an output option. And the main reason for that was so I could add a reporting option. 

Every now and again I get asked to create a quick security report to answer the question: “what permissions exist on XYZ database”. Well here is. I (and you) can now answer that question quickly and easily.'...

http://www.sqlservercentral.com/blogs/sqlstudies/2017/05/01/simple-security-report/