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. Select Like, type a specific string in the Enter match string box (you can use wildcards), and click Add. The string will be added to the Match strings box. You can also remove strings from this box by selecting the string and clicking Remove.

At the bottom section of this window, SQL Secure displays a summary of all selected objects with their respective settings if relevant (Scope and name matches).

Click Next to go to the last section of this wizard. 

To create the filter click Finish.

 

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