You can translate the question and the replies:

ROLES - SECURITY - USERS

Hi, If I create roles and users over views on DEV environement for example, and then want to duplicate the same configurations ( roles and users), how to do that? Is using revision is enough? where can we save those kind of informations and reuse them? Can we generate a file and save it? Thank you,
user
12-05-2023 09:52:50 -0400
code

1 Answer

Hi, I know of two ways you can do that in Denodo (8.0). The first way is, as already touched by your question, by creating a revision. This is also the recommended option. When you create a revision just check the "Include users and privileges" box in the "Included elements" section. However keep in mind that the revision will contain sentences to create users and roles and grant privileges only if the user that creates the revision is administrator or global administrator. Otherwise, revision will not include the statements to create users and roles, and grant privileges. Also, the revision will not include all the privileges. The revision will grant the privileges to these users and roles only over the elements included in the revision. The second way to export your User and Role information is to use the [Export Script](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/cluster_architectures_server_backup/using_the_import_export_scripts_for_backup_and_or_replication/export_script). The property *includeUserPriviliges* has to be set to *yes*. Doing so will export these elements, meaning your export includes the VQL statements to: 1. Create the users and the roles that are owners or have privileges assigned over the exported elements. 2. 2. Assign the privileges to these users/roles over the exported views. Hope this helps!
Denodo Team
15-05-2023 04:00:49 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here