question Re: How to block Hive CLI access? in Archives of Support Questions (Read Only) https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-block-Hive-CLI-access/m-p/173699#M37663 <P><A rel="user" href="https://community.cloudera.com/users/1486/smanjee.html" nodeid="1486">@Sunile Manjee</A></P><P>One way to accomplish this would be to change the permissions on the hive executable to remove read and execute access for group and other:</P><PRE>chmod 400 /usr/hdp/current/hive-client/bin/hive</PRE> Fri, 12 Aug 2016 03:51:42 GMT emaxwell 2016-08-12T03:51:42Z How to block Hive CLI access? https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-block-Hive-CLI-access/m-p/173697#M37661 <P>Hive CLI will be depercated soon. Is there any way to block invoking hive CLI? this way forcing users to only use beeline.</P> Fri, 12 Aug 2016 03:33:55 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-block-Hive-CLI-access/m-p/173697#M37661 sunile_manjee 2016-08-12T03:33:55Z Re: How to block Hive CLI access? https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-block-Hive-CLI-access/m-p/173698#M37662 <P>You could symbolic link the hive cli script/command to the beeline script command. This will ensure the "hive" command always executes "beeline".</P><P>Here is another solution: <A target="_blank" href="https://community.hortonworks.com/questions/10760/how-to-disable-hive-shell-for-all-users.html">https://community.hortonworks.com/questions/10760/how-to-disable-hive-shell-for-all-users.html</A></P> Fri, 12 Aug 2016 03:51:04 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-block-Hive-CLI-access/m-p/173698#M37662 myoung 2016-08-12T03:51:04Z Re: How to block Hive CLI access? https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-block-Hive-CLI-access/m-p/173699#M37663 <P><A rel="user" href="https://community.cloudera.com/users/1486/smanjee.html" nodeid="1486">@Sunile Manjee</A></P><P>One way to accomplish this would be to change the permissions on the hive executable to remove read and execute access for group and other:</P><PRE>chmod 400 /usr/hdp/current/hive-client/bin/hive</PRE> Fri, 12 Aug 2016 03:51:42 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-block-Hive-CLI-access/m-p/173699#M37663 emaxwell 2016-08-12T03:51:42Z Re: How to block Hive CLI access? https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-block-Hive-CLI-access/m-p/173700#M37664 <P>Of course both of these options can be worked around by anyone with access and rights to the file system.</P> Fri, 12 Aug 2016 04:01:34 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-block-Hive-CLI-access/m-p/173700#M37664 myoung 2016-08-12T04:01:34Z Re: How to block Hive CLI access? https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-block-Hive-CLI-access/m-p/173701#M37665 <P> I appreciate all the feedback.</P> Fri, 12 Aug 2016 07:43:49 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-block-Hive-CLI-access/m-p/173701#M37665 sunile_manjee 2016-08-12T07:43:49Z Re: How to block Hive CLI access? https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-block-Hive-CLI-access/m-p/173702#M37666 <P>just use doAs=true make sure only hive can read the warehouse folder and you are done. Hive cli can start but not access anything </P> Sat, 13 Aug 2016 02:05:45 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-block-Hive-CLI-access/m-p/173702#M37666 bleonhardi 2016-08-13T02:05:45Z