Information Center

Levels of filtering for schema names and table names

This online help file:

The sections in this online help file are:

Area affected by the levels of filtering
Summary of the levels of filtering
Description of the levels of filtering
Examples

Area affected by the levels of filtering

All the levels of filtering affect one single area, the list of available tables that the SQL Wizard (or the File Upload Wizard) displays at runtime. Filtering determines which schema names and table names appear in the list of available tables. See List of available tables.

Summary of the levels of filtering

This section summarizes some of the characteristics of the levels of filtering:

The person who implements the level of filtering is either the system administrator of the database, the Host On-Demand administrator, or the user.

A level of filtering has one of the following two relationships to the previous level of filtering:

A level of filtering may affect schemas, tables, or both.

The following table shows this information for each level of filtering:

Level of filtering: Person who implements: Relationship to the previous level: Affects schemas or tables:
1 System administrator (No previous level) Schemas and tables
2 Host On-Demand administrator Adds further filtering to Level 1 Schemas and tables
3 (If enabled by the Host On-Demand administrator) User Overrides and replaces the filtering in Level 2 Schemas and tables
4 (If enabled by the Host On-Demand administrator) User Overrides and replaces the filtering in Level 3 Schemas and tables
5 User Adds further filtering Schemas
6 User Adds further filtering Tables

Description of the levels of filtering

  1. Level 1. Database server
    The system administrator controls system settings that can prevent the user from seeing the names of some schemas and tables.
  2. Level 2. Table filter defined by the Host On-Demand administrator
  3. Level 3. Default value for new SQL and File Upload statements for this user
  4. Level 4. Value for the current SQL or File Upload statement
  5. Level 5. List of selected schemas
  6. Level 6. Table name filter

Examples

Example 1

  1. Level 1: In this example, there is no filtering in Level 1.
  2. Level 2: The Host On-Demand administrator specifies the following table filter: IBMTEST%, HODTEST01. This filter allows:

    The administrator does not allow the user to override the table filter.

  3. Level 3: The Table Filter field for Level 3 is not displayed, and therefore the user cannot override the table filter in Level 2.
  4. Level 4: The Table Filter field for Level 4 is not displayed, and therefore the user cannot override the table filter in Level 2.

    When the user logs on to the database server, the user sees only the schemas and tables allowed by the filter in Level 2.

  5. Level 5: The user can further narrow the List of available tables, by moving schema names to the list of selected schemas.
  6. Level 6: The user can further narrow the List of available tables, by specifying table names in the table name filter.

Example 2

  1. Level 1: In this example, there is no filtering in Level 1.
  2. Level 2: The Host On-Demand administrator specifies the following table filter: IBMTEST%, HODTEST01. This filter allows:

    The administrator allows the user to override the table filter.

  3. Level 3: The Table Filter field for Level 3 is displayed. The user overrides the table filter in Level 2 with a new table filter value: %. This new table filter value allows the user access to all schemas and tables. This new table filter value is the default value for new SQL statements and File Upload statements for this user.
  4. Level 4: The Table Filter field for Level 4 is displayed. The user overrides the table filter in Level 3 with a new table filter value: IBMTEST%.

    When the user logs on to the database server, the user sees the schemas and tables allowed by the filter in Level 4.

  5. Level 5: The user can further narrow the List of available tables, by moving schema names (such as IBMTEST01, IBMTEST204) to the list of selected schemas.
  6. Level 6: The user can further narrow the List of available tables, by including table names in the table name filter.

Related topics: