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
VQL Role
user
18-09-2017 15:55:02 -0400
code

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](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/catalog_permissions#catalog-permissions) in the Virtual DataPort VQL Guide. Hope this helps.
Denodo Team
19-09-2017 05:37:57 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here