Hi, I understand that it is possible to assign multiple roles to a specific user, and the result will be of UNION. However, is there other way to achieve the following outcome? Assuming there are several records in the database and there are 2 fields...
Answers:
1
Created new JDBC type data source and select Denodo Virtual DataPort as the Database adaptor. I was trying to create a view using 'List Roles;' using ‘Create from query’ but got the following error when executing the view. Finished with error: Error...
Answers:
3
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...
Answers:
1
Hi Team, Our project have git configured in VDP, and we can see data sources, fodlers, views are in gitlab repository, but we cannot see anything about the users, roles in gitlab repository, can we have version control for users, roles through VDP inte...
Answers:
1
Using Denodo 6.0, is there a query or service which can provide a list of roles and any roles granted to them? Obviously, the "Role Management" window has what I want ... and I want it in a way that external audit automation can pick it up. I have rev...
Answers:
2
what is the best practice to pre-load/set a variable based on the active connection to Denodo? Is this done best by creating a custom function in Java, if yes can you provide an example containing SQL as below. use-case: query current user with his/...
Answers:
1
Our database is set for LDAP Authentication. We use a model where we have one giant database with all of our data views instead of many separate databases. We have been importing LDAP roles, but as we add more views and people request unique permissi...
Answers:
3