You can translate the question and the replies:

add view to default role

Hi Team, If I create a new view, how can I automatically add it to allusers role in Denodo. Thanks.
user
15-02-2022 01:42:16 -0500
code

1 Answer

Hi, I would recommend that you set a privilege on the **database level** which automatically gives the privilege to the newly created view also. You could do that by performing the below steps: * Launch the Virtual Dataport Administration Tool * Navigate to the *' Administration > Role Management’ * * Choose the desired role and click on *‘Assign Privileges’* * Select the desired database and set needed privileges like *Connect, Metadata, Execute etc.,* For detailed explanation, you could refer to the [Types of Access Rights](https://community.denodo.com/docs/html/browse/8.0/en/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) section of the Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
15-02-2022 08:42:11 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here