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.

How to provide the Grant access for hive default database in all tables

How to provide the Grant access for hive default database in all tables

New Contributor

Hi Team,

 

I ran the below query in Hive Shell, i got the below error,

 

hive>USE default;

hive> SHOW ROLES;
FAILED: SemanticException The current builtin authorization in Hive is incomplete and disabled.
hive>

 

We are trying to provide the grant access for the user 'cloudera' for all hive  tables in default database.After we need to access the tables in SAS enviroenment with user 'cloudera'.

 

We are using imapala.odbc.drivers in SAS linux server end.

 

Can you please help me out here and let me know if you need any further inforamtion.

 

Regards,

Venkat.M

3 REPLIES 3
Highlighted

Re: How to provide the Grant access for hive default database in all tables

Expert Contributor

bad luck, i also suffered this errors when i combine the HIVE and Sentry to work together, and i have opened DEBUG for every service, but didn't find anything. 

 

anybody could help us ?

Re: How to provide the Grant access for hive default database in all tables

Expert Contributor

buddy, i hve got to resolve this problem now. 

 

i am not sure we are the same problem. because my problem is i didn't grant privileges to user by beeline, perviously, i always grant privileges by HIVE, that's wrong. 

Re: How to provide the Grant access for hive default database in all tables

Expert Contributor

another thing, be remember, if you adapter Kerberos, you must use principal to login beeline.  l

 

like:  !connect  jdbc:hive2://localhost:10000,principal=hive@yourhost@DOMAIN   

 

after login, you can create role, and grant privileges to group.