When you select the IDERA SQL Secure option Windows User or Group as the user to analyze, you can click the ellipsis button to open the Select Windows User window to browse for all the Windows users contained in the snapshot you are exploring. In this window you can:
Search for a particular account
Your list may include many users and groups. SQL Secure makes the process of finding particular users easy. Click the Filter icon that is present in each column of the Select Windows User window, and then either select the group from the list, or click Custom to sort the list using conditions.
When you choose Custom, the Enter filter criteria for Domain window opens. In this window you can add as many conditions as you require for filtering your accounts. Click Add a condition and specify any of the following options for the operator:
Sorting Option | Description |
---|---|
Equals | On the Operand list select (Blanks), (DBNull), (Empty Text) |
Does not equal | Select on of the options you have in the Operand list |
Less than | Select on of the options you have in the Operand list |
Less than or equal to | Select on of the options you have in the Operand list |
Greater than | Select on of the options you have in the Operand list |
Greater than or equal to | Select on of the options you have in the Operand list |
Like | Select on of the options you have in the Operand list |
Matches Regular Expression | Select on of the options you have in the Operand list |
Starts with | Enter the first character or characters in the column to filter your list. |
Contains | Enter a combination of letters or a name to filter your column list. |
Ends with | Enter the last character or characters in the column to filter your list. |
Does not start with | Enter the first character or characters in the column to omit from your listing. |
Does not contain | Enter a combination of letters or name to omit from your list. |
Does not end with | Enter the last character or characters in the column you want to omit from the listing. |
Does not match | Enter the title you would like to omit from your column listing. |
Not Like | Enter the name in the column you would like to omit from your column listing and all those names that are similar. |
Then, specify the respective values in the Operand column.
Add or delete as many conditions as you want, and then click OK.
Search Active Directory
Alternatively, you can click Browse Active Directory to search Active Directory for the target Windows account or group. This action allows you to select the user or group from your Active Directory domain controller rather than from the selected snapshot. It is possible the user or group you select has not been granted permissions on the audited SQL Server instance.
To successfully view the user permissions, ensure your login account has permission to access the Active Directory domain controller.