SYSDATAMASKS

Purpose

System table for role based dynamic data masking

See Also

Guide to the Users Workspace (Video), MD5(), SET ROWFILTER, SYSPERMS, SYSROLES, SYSROWFILTERS, System Tables, USERDATAMASK(), USERDOMAIN(), USEREMAIL(), USERNAME(), USERROLES(), USERROWFILTER(), Users and Roles, Users Tables

Description

The sysdatamasks table is stored in the system database and holds role based dynamic data masking information.

Column	Data Type	Width	Description
DOMAIN	C	80	Domain: Domain or tenancy for the user.
DATABASE	C	80	Database: Name of the database.
TABLE	C	80	Table: Name of the table.
COLUMN	C	32	Column: Name of the column.
ROLE	C	80	Role: Name of the role.
MASK	C	80	Mask: Mask (default | partial | email | encrypted).

Example

select * from system!sysdatamasks