As we know, in Denodo we can give a view level access for a role. I have a situation where I need to give access to a SINGLE view to MULTIPLE roles(around 30).
The procedure is to select each role, click on edit in the database and give whatever privilages the role should have on the view. But to do this procedure for around 30 roles will be very much time consuming and not an effective way.
I searched for any stored procedures but couldn't find one. Can you please suggest me any effective way where I can give access to a SINGLE view to MULTIPLE roles.
Thanks & Regards,