You can translate the question and the replies:

How do we query the catalog to find which view a webservice depends on.

What is the best way to query denodo to return the view on which a webservice or soap service is based on?
Catalog Metadata webservices
user
14-11-2017 16:17:06 -0500
code

3 Answers

Hi, In Virtual DataPort using the 'Desc' statement, I would find the dependent views that are associated with the web service by  executing the below statement in the VQL shell: `DESC VQL WEBSERVICE <web service name>  ('includeDependencies' = 'yes')` This statement would display the entire VQL of the web service and its dependent views. The ‘Catalog’ command to list Dependent views of a web service is part of our current roadmap  and would be included in the future releases of Denodo Platform. Refer the [Describing Catalog Elements](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/describing_catalog_elements/describing_catalog_elements#describing-catalog-elements) section of Virtual DataPort VQL Guide for more information on 'DESC' statement. Hope this helps you!
Denodo Team
15-11-2017 03:25:55 -0500
code
This is helpful. Do you recommend parsing the results in order to build a view? Basically, what i'm trying to do is query the catalogs to determine which roles or users have access to return data from a webservice. If i understand the security architecture correctly, a user must have read access to the view which supports the webservice, right?
user
15-11-2017 11:29:30 -0500
Hi, You could execute the 'CATALOG_PERMISSIONS' stored procedure which will return information about the privileges granted to a user/role. `CALL CATALOG_PERMISSIONS ('<username>','<rolename>')` On executing this stored procedure, you could find the privileges of an user/role which is granted over a view. In addition to that, administrator user have complete access over the web service but normal user with read, write and create privileges can only access the web service which are created by them. Refer the [CATALOG_PERMISSIONS](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/catalog_permissions#catalog-permissions) and [User and Access Right in Virtual DataPort](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/databases_users_and_access_rights_in_virtual_dataport/user_and_access_right_in_virtual_dataport/user_and_access_right_in_virtual_dataport#user-and-access-right-in-virtual-dataport) section of the Virtual DataPort Administration Guide for more information on privileges and access rights respectively. Hope this helps you!
Denodo Team
22-11-2017 08:15:07 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here