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 thes

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