If the business requirement is to limit access or mask data at the column level, you can do so by using column masks. A user with SECADM authority can create column masks on a table by using the CREATE MASK statement. The basic syntax is:
CREATE <OR REPLACE> MASK [MaskName] ON [TableName]FOR COLUMN [ColumnName] RETURN [CaseExpression]<ENABLE | DISABLE>
To which the following applies:
- MaskName: Identifies the name of the column mask, including the explicit or implicit qualifier.
- TableName: Identifies the name of the table on which to create the column mask. It must not be: a nickname; a created or declared global temporary table, view, alias, or synonym; a typed table; or a system catalog table.
- ColumnName: Identifies ...
