CREATE MASK statement

The CREATE MASK statement defines a column mask for a table.

createMask_bqu1880.png

CREATE MASK schema.maskName

This option specifies the name of the column mask for the table.

TABLE tableOwner.tableName

This option identifies the table on which the column mask is created.

ENABLE YES

This option specifies that the mask is operative for column access control on the table.

COMMENT 'commentString'

This option specifies the column mask comment.

COLUMN columnName

This option identifies a column of the table to which the mask applies.

TBCORRELATION correlationName

This option specifies the correlation name for the table for use in the maskText.

MASKTEXT(maskText)

This option specifies a case expression that is used to determine the value returned for the column.

CURRENT SCHEMA schema

This option specifies the current schema of the permission. This option corresponds to SET CURRENT SCHEMA.

PATH (schemaList)

This option specifies the path for the mask.


Related topics

CDL-statements

ALTER MASK statement

ALTER-TABLE-statement





 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*