How do you use cloud databases? Take the survey.
Options

Export / Report SQL Server Audit: login / permissions

mrdennis86mrdennis86 Posts: 1 New member
in Redgate Monitor
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
Tagged:
· Share on Twitter

Answers

  • Options
    RobynRobyn Posts: 179 Silver 5
    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). 

    Kind regards

    Robyn Edwards | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
Sign In or Register to comment.