You can translate the question and the replies:

Denodo User Name and User Description

Hi Team, When a user is created in VDP tool, there is a field "Description". Now "catalog permissions" view gives details of these users. Is there any way to find out user name along with the description which we gave while creating the user ?
user
25-10-2017 01:54:36 -0400
code

2 Answers

Please note, I want the list of all users along with their description.
user
25-10-2017 04:48:53 -0400
Hi, In order to get the list of users along with their description, I would do the following steps: 1. Create a 'New Job' of type VDP in the Scheduler Administration Tool. 1. In the Extraction section, specify the following "DESC" command in the parameterized query box in order to get the users with description. * DESC user @username 1. Then, in the Query(non parameterized) box of the source, provide the following command and add a mapping to map the parameters of the query and the source. * select distinct(username) from CATALOG_PERMISSIONS (null,null) where username is not null 1. Finally in the Exporter section, export the result as 'csv" file to get the list of the users along with their description. For more information, you can have a look at the section [General Structure of a Job](https://community.denodo.com/docs/html/browse/6.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/general_structure_of_a_job) of Scheduler Administration Guide. Hope this helps!
Denodo Team
25-10-2017 09:13:29 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here