You can translate the question and the replies:

Query Permissions by Object

Is there a way to query Denodo's catalog to return a list of roles or users who have permissions on an object?
user
14-11-2017 15:33:55 -0500
code

2 Answers

I found the procedure catalogpermissions which should solve this problem.
user
14-11-2017 16:15:20 -0500
Hi, Yes, the "CATALOG_PERMISSIONS" stored procedure would return the information about the list of users and roles with their privileges. Just keep in mind that the results returned by this procedure will change, depending on the type of user that executes this procedure. For more information, you can have a look at the section [CATALOG_PERMISSIONS](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/catalog_permissions) of Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
15-11-2017 02:32:50 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here