How do I allow Hive database creation privilege to selected users only in a secure cluster with no Sentry?
I do not want every user to have the ability to create Hive databases.
Recommend to check Setting up users in Hive? Please let us know if it is helpful.
MapR doesn't really support Sentry. (It did for Impala, but it appears no general support.) For Security you have ACEs.
With respect to Hive, when you're creating a database, or tables, its really just entries in to a RDBMs (most instances are mysql/MariaDB ). So if you want to stop database creation / table creation, you need to set permissions in Hive.
Note: Use beeline not the hive shell.
This will stop them from creating hive tables.
Then use ACEs to restrict access to table directories.
Thanks a lot for the reply.
What command should I use in beeline to stop users creating databases?
Retrieving data ...