Hey Alan, Thanks for replying. We are currently using storage based authorization and Hive 2.3.2. Unfortunately, we found that the default warehouse path requires a 777 file permission. Let us know if we completely misunderstood this requirement.
As a result, users now have the ability to create tables in default warehouse. I can look into grant and revoke statements. Mainak > On Jun 6, 2019, at 9:30 PM, Alan Gates <alanfga...@gmail.com> wrote: > > The easiest way to do this is through grant and revoke statements and/or file > permissions. Hive has several authorization schemes (storage based auth, sql > standard auth, integration with Ranger and Sentry) added over several > releases. Which version of Hive are you using and which, if any, of these > authorization schemes? > > Alan. > > On Thu, Jun 6, 2019 at 4:54 PM Mainak Ghosh <mgh...@twitter.com > <mailto:mgh...@twitter.com>> wrote: > Hello, > > We are trying to restrict our customers from creating new tables in the > default warehouse and encourage them to create their own warehouses for > simpler maintenance. Can you suggest some ways we can achieve this? > > Thanks and Regards, > Mainak
