Re: Restrict users from creating tables in default warehouse

2019-06-13 Thread Kristopher Kane
Authorization, rather. On Thu, Jun 13, 2019 at 10:51 AM Kristopher Kane wrote: > > You really have no choice with storage based authentication. > > On Fri, Jun 7, 2019 at 12:24 PM Mainak Ghosh wrote: > > > > Hey Alan, > > > > Thanks for replying. We are currently using storage based

Re: Restrict users from creating tables in default warehouse

2019-06-13 Thread Kristopher Kane
You really have no choice with storage based authentication. On Fri, Jun 7, 2019 at 12:24 PM Mainak Ghosh wrote: > > 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

Re: Restrict users from creating tables in default warehouse

2019-06-07 Thread Mainak Ghosh
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

Re: Restrict users from creating tables in default warehouse

2019-06-06 Thread Alan Gates
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

Restrict users from creating tables in default warehouse

2019-06-06 Thread Mainak Ghosh
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