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 OptionDescription
Starts withEnter the first character or characters in the column to filter your list.
ContainsEnter a combination of letters or a name to filter your column list.
Ends withEnter the last character or characters in the column to filter your list.
Does not start withEnter the first character or characters in the column to omit from your listing.
Does not containEnter a combination of letters or name to omit from your list.
Does not end withEnter the last character or characters in the column you want to omit from the listing.
Does not matchEnter the title you would like to omit from your column listing.
Not LikeEnter 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.

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