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
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 ```
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]( 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