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.

separate users database in Hive

separate users database in Hive

New Contributor

Hi,

I am using hive.

I have 10 users, I have 12 databases.

 

I need to limit the access to databases.

I want to allow access user A access to database A  and user B access to database B.

 

can any one help ?

4 REPLIES 4

Re: separate users database in Hive

Master Guru
Your use case is pretty standard in what Sentry can achieve. Have you read through the Sentry documentation already? http://www.cloudera.com/documentation/enterprise/latest/topics/sg_hive_sql.html

Re: separate users database in Hive

New Contributor

I have just saw it yesterday.

and I am about to test it.

 

I have understand that I need to enable/setup the  Authorization.

 

 

Re: separate users database in Hive

New Contributor
While I am creating new service for sentry, I was asked to enter DB (postgrs,mysql,oracle)
Do I must create external DB ?
Highlighted

Re: separate users database in Hive

Guru

Hi,

 

Sentry supports both file based and service based, however, the service based approach is highly recommended. And in order to use the service based Sentry, a backend database is required.

 

More information about Sentry can be found below.

 

Sentry Service:

http://www.cloudera.com/documentation/enterprise/latest/topics/cm_sg_sentry_service.html

 

Sentry Policy File Authorization

http://www.cloudera.com/documentation/enterprise/latest/topics/cdh_sg_sentry.html

 

Hope this helps.

 

Thanks