I was facing the similar issue when I try to create a view using DESC role command. However, I was able to get the information about the privileges granted to a user and/or a role by using CATALOG_PERMISSIONS Predefined Stored Procedure. To create a view using this Predefined Stored Procedure, you can follow the below steps:
* Open VQL Shell and execute the similar VQL like below to create the view:
`create or replace view <view_name> as select * from catalog_permissions()`
* Once the view is created, open the view and select "Edit>Model>View parameters" to create a parameters of your choice(for example: 'param_UserName' and 'param_RoleName') and leave the Default value column blank.
* Next, navigate to the 'Where conditions' tab and provide the conditions in the following example format:
catalog_permissions.username = param_UserName
catalog_permissions.rolename = param_RoleName
Now, when you execute this view, you will be prompted to enter values for the view parameters and the results will be based on these values.
For more details, you can refer to [CATALOG_PERMISSIONS](https://community.denodo.com/docs/html/browse/latest/vdp/vql/stored_procedures/predefined_stored_procedures/catalog_permissions#catalog-permissions) section of the Virtual DataPort VQL Guide.
If you still need help and if you are a valid Support User, you may open a Support Case at the Denodo Support Site and the Support Team will help you.
Hope this helps!