You can translate the question and the replies:

Masking data vs Data Integration or Reporting tool

Hi, I wish know how Denodo is masking data during a data query from a Data Integration tool (Informatica, Data Stage, SAS Data Integration, ecc.) and/or Reporting tool (Visual Analytics, Power BI, ecc.) by a normal user. The query execution will be made using a technical user or that one of the user with whom he authenticated himself on the tool? Thank you for help Andrea
user
10-10-2018 07:09:01 -0400

2 Answers

Hi, In general, Denodo uses User and Role privileges to manage different types of access rights. Access rights can be defined on different granualarity, i. e. Database, View, Colum/Row level as well as different levels of operations. The user who is logged in to access the Denodo Server is the one who's authentication and privileges are checked against the elements in the Denodo Server. For instance, you have a user A who is existing in the Denodo Server and you use a JDBC-Application to access the Denodo Server using the credentials of user A. This means, the Denodo server will check user A's privileges and access rights against the server and acts accordingly upon it. It is also possible to define roles with certaing privileges and access rights, such that privileges and rights can be managed for multiple users at once. Please see [User and Access Right in Virtual DataPort](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/databases_users_and_access_rights_in_virtual_dataport/user_and_access_right_in_virtual_dataport/user_and_access_right_in_virtual_dataport#row-restrictions) as well as [Denodo Security Overview](https://community.denodo.com/kb/view/document/Denodo%20Security%20Overview?category=Security) for a better understanding of this subject. Hope this helps!
Denodo Team
15-10-2018 02:48:20 -0400
Hi Thank you for informations. Its help us a lot Regards Andrea
user
16-10-2018 03:44:20 -0400
You must sign in to add an answer. If you do not have an account, you can register here