Created 05-23-2018 09:43 PM
I have a hive view user and wouldn't want him to save the query results. How should I go about restricting him from doing it.
Created 05-23-2018 09:57 PM
The Saved Queries tab in the Hive View shows all the queries that have been saved by the current user. Users can click the gear icon to the right of the query list to view the history of a query or to delete it: https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.2.0/bk_ambari-views/content/section_saved_queri...
.
Created 05-23-2018 10:01 PM
I am not tlking about the saved queries. I am saying about the query results itself. There is a option to download the results to HDFS / csv. I don't want my user to do that. I would want to restrict them from downloading any production data results.
Created 05-23-2018 10:33 PM
Unfortunately it is not possible to disallow any specific user to now be able to save the results.
The "Save As" button in the Hive View can be tweaked little bit using the Java script manipulation a bit to disable the "Save As" permanently for all users though. But that is not a good solution.
Also the results will still be displayed in the UI after query execution and even the API response will have the JSON result. Which can not be restricted without a major Logic/UI change.
Created 05-23-2018 10:37 PM
Thats a good point. I would like to restrict save for all users. Can you tell me what needs to be manipulated to disable it.