Data Director Implementation Guide

10.3

Back Next

Data Security Using Filters

Data security in Informatica Data Director is configured using the

Subject Area

dialog in the Informatica Data Director Configuration Manager. You can define filters on the subject area column to restrict and secure subject area data that individual users can access. Filters can be defined on primary object column, child column and grandchild column. You can set up any number of filters for a subject area and subject area group column.

Informatica Data Director data security supports the following types of values for security filters in table column type in the database:

String

Integer

Float

Table column value of type Date is not supported by data security filters of Informatica Data Director.

Consider the following rules and guidelines when you work with filters:

Each security filter is defined on columns in the subject area and consists of a filter value to be applied to a list of roles.

Security filters are based on exact values and not on wild card comparisons or ranges.

Filters must be defined on the match columns to apply security filters consistently across basic, extended, and advanced searches.

Filters can be combined. A user with multiple roles can have combinations of filters applied. The result is that a user has access to all the data available in each assigned role through a union of the filter assignments.

Filters on different columns can be combined to create multi-dimensional data security.

Multiple filters on a single column for a single role. A user has access to a union of all data that meet each filter.

Filters on multiple columns for a single role. A user has access to intersection of all data that meet each filter.

In IBM DB2 environments, filters on columns with a datatype of float do not filter beyond the scale of the column. For example, if the scale of the column is 1 and you set the filter to 1.2, values that are beyond the scale of the column, such as 1.21, are also accessible.

For more information, see the

Configuration Manager

online help.

Data Security Overview

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal