You can translate the question and the replies:

Restricting "Create view" and "Write" privilege to a view

Hi all, Is it possible to have a role with Connect and Execute/Metadata privileges only (read-only) + Create view and Write privileges on a single view from the virtual database? The use case is a view that dynamically create a base view through a Dendo Stored procedure. Currently, my users needs to have Create view and Write privileges over the whole virtual database to be able to execute the view that creates the dynamic base view. I'd like to restrict this Create view and write privileges to the execution of this view. Thanks.
user
05-02-2020 03:20:42 -0500
code

1 Answer

Hi, In Virtual DataPort Server views, data sources, data services are always created at the database level but not at view level, so you can assign create view privilege at the database level and it is not possible to have a create view option at the views level. For your scenario, for a particular role I would assign Connect and Create views Privileges at the Database level and Write, Execute and Metadata privileges for a single view at the views level by clicking on **edit** option under the **Advance privileges** column for a respective database. For more details, you can refer to the [Creating Roles](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/databases_users_and_access_rights_in_virtual_dataport/administration_of_databases_users_roles_and_their_access_rights/creating_roles#creating-roles) and [Types of Access Rights](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#types-of-access-rights) sections of the Virtual DataPort Administration Guide. If you still need help and if you are a valid Support User, you may open a Support Case at the Denodo Support Site and the Support Team will help you. Hope this helps!
Denodo Team
05-02-2020 07:07:41 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here