Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here. Want to know more about what has changed? Check out the Community News blog.

Error when creating a new database

Highlighted

Error when creating a new database

New Contributor

When trying to create a new database through the Metastore Manager, an error occurs.

 

This is the error that is displayed:

 

QueryServerException at /beeswax/create/database

 errorMessage='Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [......] does not have [USE] privilege on [default]

 

Access to the default database is not granted to users, but Hue insists on accessing the default database when creating a new database.

 

Could anyone help with a solution to this problem?

2 REPLIES 2

Re: Error when creating a new database

This means that your user does not belong to a group with the privileges to
query Hive
http://gethue.com/apache-sentry-made-easy-with-the-new-hue-security-app/

Re: Error when creating a new database

New Contributor

Is there a work around for this? Is there a way for users to create a new database without having to grant them full permissions? Hue shouldn't need to run queries on the default database when creating a new one, correct?