When you select to analyze a SQL Server Login through IDERA SQL Secure, you can click the ellipsis button  to open the Select SQL Login window that lists all of the SQL logins contained in the snapshot you are exploring.

You can filter this list by clicking the filter on the top right section of the Type column. You can filter by All, Custom, Blanks, NonBlanks, SQL Login. 

If you select Custom, a new window for Enter filter criteria for type opens. In this window, you can add as many conditions as you require. To view more information about the operators for these conditions, you can go to Select a Windows User. 

Select the login whose permissions you want to explore, and then click OK.

SQL Secure tells you who has access to what on your SQL Server databases. Learn more > >
  • No labels