How can we help you today? How can we help you today?

Export / Report SQL Server Audit: login / permissions

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
mrdennis86
0

Comments

3 comments

Sort by
  • 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). 

    Robyn
    0
  • mrdennis86
    Robyn said:
    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). 

    i Robyn, 

    Do you know if this option is availible now in SQL monitor? i want to create a report with the user permissions
    mrdennis86
    0
  • Robyn
    Hi Dennis, 

    Not yet! There's some permissions information now included with enterprise tier of Redgate Monitor (with option to export) that might match your use case but It's still in early stages and development's hoping to expand what's captured here with additional auditing.

    We do have a demo site that I'll link below to give you an idea. 
    https://monitor.red-gate.com/Security/Permissions
    Robyn
    0

Add comment

Please sign in to leave a comment.