turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Do you mean 
Reply
benhadoop
Explorer
benhadoop
Posts: 14
Registered: ‎12-14-2015

Sentry / Impala: Grant read permissions to all databases

[ Edited ]

‎02-11-2019 06:13 AM - last edited on ‎02-11-2019 01:58 PM by Community Manager

Hi community,

 

I got CDH 5.16 and a cluster with Impala / Hive / Sentry (database-backed) set up.

 

In Impala, I got different databases and want to define policies so that a group / role can access all databases read-only.

 

I tried this Grant but it does not work:

 

"GRANT SELECT ON DATABASE ALL TO ROLE my_role;"

 

 

How can I define SELECT-permissions for all databases in Sentry?

 

Thanks!

Benjamin

Report Inappropriate Content
Message 1 of 2 (101 Views)
Labels:
Reply
0 Kudos
Highlighted
benhadoop
Explorer
benhadoop
Posts: 14
Registered: ‎12-14-2015

Re: Sentry / Impala: Grant read permissions to all databases

‎02-11-2019 06:40 AM

Quite strangely, the same GRANT Query seems to work when running through HiveServer2 (e.g. using beeline). Is this an Impala Bug?

Report Inappropriate Content
Message 2 of 2 (97 Views)
Reply
0 Kudos
Announcements

Share Your Thoughts