Latest Activity

code

RBAC using Stored Procedures

Hihi, I’ve tried to implement a modular RBAC via stored procedures as shown in the code below. While the GRANT statements seem to work, the REVOKE statements on views do not. Could you please assist with this issue? Additionally, I would like to ext...

Custom stored procedure Access and Role

code

Restrcit VCS management for read-only users

Hello, I have noticed that users with read-only access can also perform VCS operations. Is there a way to limit this? My test user only has "Connect", "Metadata" and "Execute" rights. With this user I was able to perform a push operation. In my opinion...

VCS Access and Role Denodo Design Studio

code

Impersonate a Role in Denodo

Hi, Being an Admin on a Denodo server ,is there a way I can impersonate a certain role and verify if that Role has all the intended access or not ? thank you !

Access and Role

code

add view to default role

Hi Team, If I create a new view, how can I automatically add it to allusers role in Denodo. Thanks.

Access and Role

code

Desc role with a rolename having special character(hyphen)

Hello, When I am trying to run the describe role statement (Desc role role-name) I get an error as, Syntax error: Exception parsing query near '-' I tried executing the statement (Desc role 'role-name') but got the error as, Syntax error: Exception p...

Access and Role Roles DESC

code

Granting access to virtual database without access to VDP

Hi, I would like to know if it is possible to grant read access to a virtual database to an user without granting him access to the Virtual Dataport administration tool? i.e. the user can execute view from a client tool as Excel, but cannot directly ...

privileges Access and Role

code

How to identify or eliminate the pre-defined admin roles from LIST Roles

Dear Friends, I am using LIST ROLES to get list of all the roles from denodo. I don't want to see pre-defined admin related roles in my list of roles. I mean, I don't want to see the following pre-defined roles (data_catalog_admin, data_catalog_classi...

Access and Role

code

Provide access to SINGLE view to MULTIPLE roles

Hello team, 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 wh...

Denodo stored procedure database assign privilages Base View descrptions Access and Role Stored Procedure VQL Role Role and User Management Roles Users

code

Different roles within the same Distribution List

We have configured an LDAP authentication in our Denodo system. We have different databases created meant for different users but under the same Distribution List(DL). So if i want to assign privilege for a user to a particular database from the DL, wi...

Access and Role Role and User Management