Difference between revisions of "SYSDATAMASKS"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 21: | Line 21: | ||
|ROLE||C||80||Role: Name of the role. | |ROLE||C||80||Role: Name of the role. | ||
|- | |- | ||
| − | |MASK||C||80||Mask: Mask. | + | |MASK||C||80||Mask: Mask (default | partial | email | encrypted). |
|- | |- | ||
|} | |} | ||
Revision as of 11:41, 24 February 2017
Contents
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). |
Supported from Lianja v3.4.
Example
select * from system!sysdatamasks
