Creating Sets

Learn about the types of sets and how to create them.

The following are the types of sets that can be configured and used in the rules:

  1. IP Address Sets: A list of IP addresses of client programs (IPv4 format).

  2. Database User Sets: A list of database user names.

  3. OS User Sets: A list of operating system user names.

  4. Client Program Sets: A list of client programs. For example SQL*Plus.

  5. Database Object Sets: A list of tables to be evaluated by a policy.

  6. SQL Cluster Sets: A list of SQL clusters. A SQL cluster is a group of SQL statements created automatically by Database Firewall that are similar, from the network traffic.

To create local sets:

  1. Log in to the Oracle Database Security Central console as an auditor.

  2. Select Policies.

  3. Select Database Firewall Policies in the left navigation menu.

  4. Select the name of the specific policy. The details of the policy are displayed in the main screen.

  5. Select Sets/Profiles in the top right corner. This page lists the sets already defined for the specific policy.

  6. Select one of the following:

    • IP Address Sets

    • Database User Sets

    • OS User Sets

    • Client Program Sets

    • Database Object Sets

    • SQL Cluster Sets

  7. Select Add to add a new local set.

  8. Use the dialog box to complete adding a new local set.

    Note: If you’re importing a file, it must be encoded in the UTF-8 format.

  9. Select Save. The new local set appears in the specific policy page.

  10. Select Add to add more local sets for the specific set.

see Discover & Classify to create global sets.