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
EqualsOn the Operand list select  (Blanks), (DBNull), (Empty Text)
Does not equalSelect on of the options you have in the Operand list
Less thanSelect on of the options you have in the Operand list
Less than or equal toSelect on of the options you have in the Operand list
Greater thanSelect on of the options you have in the Operand list
Greater than or equal toSelect on of the options you have in the Operand list
LikeSelect on of the options you have in the Operand list
Matches Regular ExpressionSelect on of the options you have in the Operand list
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.


IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels