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 <[email protected]> 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 <[email protected] > <mailto:[email protected]>> 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
