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. https://community.denodo.com/answers/question/details?questionId=9060g000000XeRhAAK&title=List+of+Roles+and+complete+hierarchy I also tried the offered solution here using Catalog Permisions() but this does not return all the roles only the roles I have. https://community.denodo.com/answers/question/details?questionId=9060g0000004FTKAA2&title=Create+a+view+using+%27List+Roles%3B%27+Denodo+Virtual+DataPort+datasource How do I return all the roles and privileges for all roles?
Roles privileges
user
24-01-2023 11:37:48 -0500
code

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](https://community.denodo.com/kb/en/view/document/How%20to%20obtain%20permissions%20of%20LDAP%20users) article in the Knowledge Base. Hope this helps!
Denodo Team
 Edited on: 25-01-2023 15:50:44 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here