Previous Topic: CA User Activity Reporting Module-specific Error CodesNext Topic: Example: Preparing to Use ODBC and JDBC Clients with Crystal Reports


Example: Use an Access Filter to Limit ODBC Results

You can create an access filter to limit the data returned to an ODBC access request. When members the named application group accesses CA User Activity Reporting Module event data using the ODBC client, they see only the information allowed by the filter.

This example assumes that you have an application group named UNIX_Analysts and that you want to restrict all members of that group to see only UNIX events from the event log store. The filter created in this example limits event data views from within the CA User Activity Reporting Module user interface and external requests through ODBC.

More information about access filters is available in the online help.

To create an access filter

  1. Log in to CA User Activity Reporting Module as an Administrator user.
  2. Click the Administration tab, then click the User and Access Management subtab.
  3. Click New Access Filter New Access Filter button. The Access Filter Design wizard starts.
  4. Enter UNIX Analysts for the Name field, and the phrase, UNIX Analysts access filter in the Description field, and then click step 2 Identities at the top of the dialog.
  5. Change the Type to Application Group and type UNIX in the Name field and then click Search Identities.

    A list of identities matching your search criteria appear in a shuttle control so that you can select the desired identities.

  6. Select the UNIX_Analysts application group from the Available Identities list and click the right arrow shuttle control to move the selection into the Selected Identities list.
  7. Click step 3 Access Filters at the top of the dialog.
  8. Click New Event Filter Add button to add a line, and then click the field area under Column.
  9. Select event_logname from the drop-down list, and then click the field area under Value.
  10. Select Unix from the drop-down list. Your dialog resembles the following:

    This illustration shows the completed advanced filter page of the Access Filter Design wizard.

  11. Click Save and Close.