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.

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?

Don't have an account?
Coming from Hortonworks? Activate your account here