Reply
New Contributor
Posts: 4
Registered: ‎08-19-2014

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

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

Expert Contributor
Posts: 162
Registered: ‎09-29-2014

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

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 ?

Expert Contributor
Posts: 162
Registered: ‎09-29-2014

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

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. 

Expert Contributor
Posts: 162
Registered: ‎09-29-2014

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

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.