You can translate the question and the replies:

List role by assignment

Hi, I have Role A and assgin to Role 1, 2, 4, 5. Right now I have to open Role 5 to check if Role A from role management. Is there a vql to list Role 1,2,4,5 by Role A? thanks
18-09-2017 15:55:02 -0400

1 Answer

Hi, I tried the following query and it worked for me. Execute the following in the VQL Shell of the Virtual DataPort Admin Tool: select userrolename from catalog_permissions() where rolename='RoleA' This will return the roles that inherit from the RoleA. You can also refer to [Catalog_Permissions]( in the Virtual DataPort VQL Guide. Hope this helps.
Denodo Team
19-09-2017 05:37:57 -0400
You must sign in to add an answer. If you do not have an account, you can register here