This window allows you to select which databases you want to audit using IDERA SQL Secure.

OptionsDescription
User databases and System databases

For some objects, the Scope Matches column allows you to select if you want to use System, User, or both (System or User) databases types for your snapshot.

Databases names matching
  • Select Any if you want to include all databases names in your snapshot.
  • If you want to specify strings that your filter will use to match the names of your databases, click Any on the Name matches column, and a new window opens. In the list of available elements, click the elements you want to move to the Selected list, and then click Add. You can search for a specific element by typing a specific string in the Enter match string field (you can use wildcards), and then click Add. The string added to the Match strings field. You can also remove strings from this box by selecting the string and clicking Remove.

To create the filter click OK.

 

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