Page History

In the Select SQL Server SQL Server Objects to Audit section section of this wizard, you can specify which the database or server objects IDERA SQL Secure will audit to collect security information. By default, SQL Secure audits all SQL Server SQL Server objects.

To select objects to audit:

1. Check the objects you want to audit in the list.
   Image Added
2. For those objects that have scope options, click the text in the Scope matches column, and select the appropriate option (User, System, System, or User).
3. For those objects that have naming options, click the text in the Name matches column, and a new window opens with the following options:
   
   • • In the first part of the window, select the elements you want to move to the Selected list, and then click Add. You can remove the added elements from the list by selecting the element and clicking Remove.
     • On the Names matching box, select Any
   Names matching Like where you can type several name strings (wildcards allowed). To add a name, type in the respective Enter match string box and click Add. The added names will be listed in the Match Strings box. You can use the option Remove to delete match string names from the list. 
   • • if you want to include all elements names in your snapshot.
     • If you want to specify strings that your filter will use to match the names of your databases, click Like to enable new options on the Name matching box.  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 Match strings field added strings. You can also remove strings from this box by selecting the string and clicking Remove.
       Image Added
       
       
4. SQL Secure displays at the bottom section of this window a summary of all selected objects and their specified settings.
5. Click Next to go to Schedule Snapshots.