Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:

...

Then, specify the respective values in the Operand column.

Add or Delete delete as many conditions as you want. Click , 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.

Note

To successfully view the user permissions, ensure your login account has permission to access the Active Directory domain controller.

...

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