Thanks for jumping in here 😉 @mathieu.d , @saranvisa : I did further playaround in this 5.8 sandbox, and even using the Hue=>Security UI produces the same error/issue. What I did: - created 2 groups in Linux (one for read-only, the other for read-write) and added users to it - created 2 roles in sentry (again, one for read-only and the other for read-write) and granted corresponding previously created group to it - created a hive database "sentrydemo" and one table in it - open 2 terminals with 2 different users (one 'read', and one 'read-write') and connect to hive via beeline - "select * from hivetablename" works fine - "insert into hivetablename values (100, 'test entry')" gives me the following error: The required privileges: Server=server1->Db=sentrydemo->Table=values__tmp__table__2->Column=tmp_values_col1->action=select; (state=42000,code=40000) "Enable Sentry synchronisation" is enabled in HDFS config, the "real" table folders have the correct permissions set according to the groups. Where are those "values__tmp__table..." 's are being stored and why are they not being considered by the Sentry permissions I defined ?!?! Any ideas ? At the end it is not either just a "INSERT only permission not working", right now it is a general "INSERT" not working issue, since the "read-write" group has privileges "SELECT" & "INSERT"
... View more
