Using Denodo 6.0, is there a query or service which can provide a list of roles and any roles granted to them? Obviously, the "Role Management" window has what I want ... and I want it in a way that external audit automation can pick it up.
I have reviewed the Catalog Permissions procedure, but that only shows object grants and inheritance for those objects which are granted. It does not, for example, show if another role is granted "serveradmin" since nothing is granted to serveradmin. Audits need to check for things like admin access.
Yes, exporting the entire server VQL would give the raw detail just like looking at the Role Management window. I am looking for something simple, which can be used by any external mechanism (query, web service, etc.). And parsing the large server export would be painful.