Export / Report SQL Server Audit: login / permissions

mrdennis86

Hi,

im seaching for a report or export for the servers that i monitored with the SQL monitor tool. 
Does anyone have this? or know if this is possible?

I need a report/export for all SQL logins and there permissions on the datababases and roles.

Regards

Dennis

Robyn

Hi Dennis, 

Thanks for your post! 

The feature you are after doesn't yet exist for SQL Monitor. However, the possibility of making it a feature is in discussion and we hope to see it on the roadmap soon! 

Although it is not a report, there is the Permissions section on the server overview that shows which logins have those three specific high permissions roles (sysadmin, serveradmin, securityadmin).