Reply
Highlighted
Explorer
Posts: 14
Registered: ‎12-14-2015

Sentry / Impala: Grant read permissions to all databases

[ Edited ]

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

Explorer
Posts: 14
Registered: ‎12-14-2015

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

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

Announcements