You can translate the question and the replies:

Identify views/roles on which custom policy is applied

I have created a custom policy and have asked our denodo administrator to apply them on few roles and views. I would like to verify those details (since I do not rights to apply custom policies). Is there a stored procedure or function which will allow me to view the dependencies (roles and views) on which Custom Policy is applied?
16-12-2016 05:19:40 -0500

1 Answer

Hi, Virtual DataPort includes a Stored Procedure called CATALOG_PERMISSIONS that returns that kind of information. However, given that you cannot assign Custom Policies to other users/roles, for security reasons you cannot check the custom policies applied to others user/roles either. If I were you, I would ask your VDP Administrator to execute the Stored Procedure to check that the custom policies were applied correctly. Hope this helps!
Denodo Team
20-12-2016 10:13:27 -0500
You must sign in to add an answer. If you do not have an account, you can register here