You can translate the question and the replies:

Return all the privileges for the Roles created in the Denodo VDP.

Hi, I am trying to create a report on the privileges that each role has witin Denodo so that I can tie this into a report on Active Directory user and groups I already have. The idea is to return every role and the privileges returned byt the desc role command. I have followed the article here but it does not return the Privleges column so is does not provide the information required. I also tried the offered solution here using Catalog Permisions() but this does not return all the roles only the roles I have. How do I return all the roles and privileges for all roles?
24-01-2023 11:37:48 -0500

1 Answer

Hi, To return the roles of LDAP users, I followed these steps: * Define an LDAP data source in VDP * Import roles from the LDAP server * Assign the privileges to imported LDAP roles * Create base views to obtain the users and groups * Create derived views to make transformation * Create Join views to obtain role privileges of LDAP users * Join the view from the previous step with the 'catalog_permissions()' stored procedure For more information and detailed steps, please refer to the [How to obtain permissions of LDAP users]( article in the Knowledge Base. Hope this helps!
Denodo Team
 Edited on: 25-01-2023 15:50:44 -0500
You must sign in to add an answer. If you do not have an account, you can register here