Q&A BY TAG 'Roles'

You must sign in to ask a question. If you do not have an account, you can register here

Roles Assignment
answered 15-01-2021 04:22:23 -0500

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

roles

Create a view using 'List Roles;' Denodo Virtual DataPort datasource
answered 19-06-2020 07:16:36 -0400

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

VDP Roles

Desc role with a rolename having special character(hyphen)
answered 11-06-2020 03:23:00 -0400

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

Access and Role Roles DESC

Denodo VCS for Users, Roles with git
answered 31-03-2020 10:32:06 -0400

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

git VSC Roles Users

Is there a query to see role-to-role assignments?
answered 28-02-2019 06:34:23 -0500

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

roles Role and User Management

best practice for user session variable/attribute
answered 02-11-2017 01:26:58 -0400

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

getsession roles

Managing Roles
answered 29-10-2014 17:24:53 -0400

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

vdp roles