You can translate the question and the replies:

User Metadata Access

Is it possible for the user to view the metadata for all the base views across all databases/schemas but limited to query only the data they are entitled to those base views?
20-05-2021 10:49:52 -0400

1 Answer

Hi, I am able to set up permissions that expose Metadata to my users, independent of their Execution permissions, by making use of the User and Role Management features in the Virtual DataPort Administration tool. These can be found under Administration > User Management and Administration > Role Management respectively. Once I have opened either of these windows, and selected the desired Users or Roles from the listing, I can click ‘Assign Privileges’ at the top of the pane to open the list of privileges I can assign. The metadata of a given view can be seen by any user with the Metadata Privilege granted to them, but they will require Execute Privileges as well in order to query that View. Note that a User who is granted Execute Privileges is implicitly granted Metadata Privileges, but a User can be granted Metadata Privileges without granting them Execute Privileges as well. For more detailed information about the permissions that can be granted, see the [Types of Access Rights]( ) section of the Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
20-05-2021 17:59:32 -0400
You must sign in to add an answer. If you do not have an account, you can register here