You can translate the question and the replies:

Denodo data catalog description version

Hi Team, Is it possible to multiple version of description for a view in Data catalog Can we create/ set a owner for the views simirar to ms word properties( Author, created date etc) THanks Balu S
user
12-11-2019 03:01:00 -0500

1 Answer

Hi, I understand that your situation is that you want to have multiple different descriptions at the same time and display one or the other depending on the user querying the view. What I would do is create multiple virtual databases with the exact same views and give the necessary privileges over each one to the interested role or user. This way when these users log into the Data Catalog they will see just the virtual database with the appropriate description. You can take a look at the documentation on [Exporting the Server Metadata](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/exporting_and_importing_the_server_metadata/exporting_the_server_metadata/exporting_the_server_metadata) in order to export your current database and create an exact replica. Then you can take a look at [Modifying and Deleting Users](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/databases_users_and_access_rights_in_virtual_dataport/administration_of_databases_users_roles_and_their_access_rights/modifying_and_deleting_users) in order to grant the necessary privileges to each user Regarding the ownership of views I would review the documentation on [Ownership of Elements](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/creating_databases_users_roles_and_access_privileges/ownership_of_elements/ownership_of_elements). Basically you can either change it with the CHOWN command or use the [GET_VIEWS](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/get_views#get-views) stored procedure to see the owner, created date, etc. Hope this helps!
Denodo Team
12-11-2019 18:58:01 -0500
You must sign in to add an answer. If you do not have an account, you can register here