You can translate the question and the replies:

Granting access to virtual database without access to VDP

Hi, I would like to know if it is possible to grant read access to a virtual database to an user without granting him access to the Virtual Dataport administration tool? i.e. the user can execute view from a client tool as Excel, but cannot directly connect to VDP. I tried to grant the user the execute access without the connect access but it appeared to fail. Even after I tried to run: SET 'com.denodo.vdb.security.requireConnectOnCrossDatabaseAccess' = 'false'; from VQL shell. (I tested with the user that runs tests from Denodo testing tool, if that makes any difference) Any solution? Thanks.
user
05-02-2020 03:03:14 -0500

1 Answer

Hi, Virtual DataPort Administration Tool is a client tool for the Virtual DataPort Server just like DBVisualizer, Excel, the difference being, this tool would be extensively used for developing views in the Virtual DataPort Server. The User authentication from all of these Client tools is managed by Virtual DataPort server. If you don’t want any user activity to be executed via Virtual DataPort Administration tool, I recommend you to create a [Plan](https://community.denodo.com/docs/html/browse/latest/vdp/administration/resource_manager/defining_a_plan/defining_a_plan#defining-a-plan) which would stop all queries and have this plan executed for a [Rule](https://community.denodo.com/docs/html/browse/latest/vdp/administration/resource_manager/defining_a_rule/defining_a_rule#defining-a-rule) **User Agent** **-->** **'Denodo-VDP-AdminTool'**. A rule if defined like above would restrict execution of queries coming from the Virtual DataPort Administration Tool. This way Virtual DataPort Users (even admin user) cannot perform any queries on the Virtual DataPort Server via the Virtual DataPort Administration Tool. I recommend you to read through [Resource Manager](https://community.denodo.com/docs/html/browse/latest/vdp/administration/resource_manager/resource_manager#resource-manager) section of the Virtual DataPort Administration Guide for detailed steps to create the above said Plans and Rule. Hope this helps!
Denodo Team
05-02-2020 05:52:27 -0500
You must sign in to add an answer. If you do not have an account, you can register here