You can translate the question and the replies:

Is there a query to get a list of views with EXECUTE permission for current user?

I want to list views accessible by the current logged user. Seems I should use GET_VIEWS(), GET_PERMISSIONS() and GET_EFFECTIVE_PERMISSIONS(), but cannot realize how
user
26-07-2021 06:10:03 -0400

2 Answers

I realized, it is just ``` select elementname from get_catalog_effective_permissions('admin') where elementtype = 'View' and elementexecute = true ```
user
26-07-2021 06:15:43 -0400
Hi, I am glad that you got it working. You could refer the section [GET_CATALOG_EFFECTIVE_PERMISSIONS](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_catalog_effective_permissions#get-catalog-effective-permissions) of Virtual DataPort VQL Guide for more information. Hope this helps!
Denodo Team
26-07-2021 17:08:48 -0400
You must sign in to add an answer. If you do not have an account, you can register here