DATA_MASK_INHERITANCE

This option defines materialized views mask inheritance behavior

Value

Descrition

TRUE

Default masks are applied to the columns of the materialized views which use masked underlying object columns.

Masks conditions are not taken into account. Default masks applied to all values of masked column.

Default masks are following:

For string data types, use XXXX or fewer Xs if the size of the field is fewer than 4 characters
For numeric data types use a zero value
For date and time data types use 01.01.1900 00:00:00.0000000
For binary data types use a single byte of ASCII value 0 (binary, varbinary, image)

The value of this option can only be changed by the members of the admin roles.

Default value.

FALSE

Masks are not applied to the columns of the materialized views which use masked underlying object columns.