Defining Filters for Users

The users filter restricts the workload to include or exclude SQL statements executed by users that you specify.

To define a filter for users: 

1. On the SQL Access Advisor: Workload Source page, under Users, select Include only SQL statements executed by these users or Exclude all SQL statements executed by these users.

2. To search for available users, click the Users search icon.

   The Search and Select: Users dialog box appears.

3. Select the users whose SQL statements you want to include or exclude and then click Select.

   The Search and Select: Users dialog box closes and the selected tables now appear in the Users field.