USERDATAMASK()

Purpose

Function to return the dynamic data mask for the specified column for the current user.

Syntax

USERDATAMASK(<cTable>, <cColumn>)

See Also

FILTER(), Guide to the Users Workspace (Video), MASKEDDATA(), MD5(), SET FILTER, SET ROWFILTER, SYSDATAMASKS, SYSPERMS, SYSROLES, SYSROWFILTERS, System Tables, USER(), USERDOMAIN(), USEREMAIL(), USERFULLNAME(), USERNAME(), USERROLES(), USERROWFILTER(), Users and Roles, Users Tables, USERTENANCY()

Description

The USERDATAMASK() function returns the dynamic data mask for the specified column in the specified table for the current user. Dynamic data masks are based on authenticated user roles and defined in the Users workspace.

Supported from Lianja v3.4.

Example

open database southwind
? username()
? userdatamask("customers","customerid")