The Select Windows User window lists all the Windows users contained in the snapshot you are exploring. Select the Windows account whose permissions you want to explore, and then click OK.
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 on the Select Windows User window, and then either select the group from the list or click Custom to sort the list using the following criteria:
| Sorting Option | Description |
|---|---|
| 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. |
Search Active Directory
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.