You can translate the question and the replies:

row security

Hi Team, Denodo 7.0 Where to find 'mask' and 'map' functions ? I saw them here: Thanks.
09-09-2022 03:18:51 -0400

1 Answer

Hi, As per the video, **Masking the sensitive field **option is used for hiding the sensitive information returned to the user. To make use of this feature, I would apply the [**Row Restrictions**]( privilege to the role/user by performing the below steps in the Virtual DataPort Administration Tool: * In the "Administration menu > User Management/Role Management", click on the “Assign privileges” option * Choose the particular database in which the element exists and select “Advanced Privileges”>”Edit” option. * Click on the particular element to apply restriction. * In the “simple condition” tab, specify the particular condition and enable the **“Mask sensitive fields if ANY of them are used”** option to mask the row. * Then, select the sensitive column to be masked. Additionally, the [**Map()**]( function is used to return the value associated with the key. To create maps, I would use the [CREATE MAP]( command in the VQL shell of the Virtual DataPort Administration Tool like: > CREATE MAP { I18N | SIMPLE } <name:identifier> ( [<name:literal> = <value:literal>]+ ) ) Hope this helps!
Denodo Team
09-09-2022 08:54:17 -0400
You must sign in to add an answer. If you do not have an account, you can register here