[RANGER-4704] Not able to perform materialized views rebuild if user is granted update access after initial deny of operation

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: plugins
• Assignee: Unassigned
• Reporter: suja s
• Created: 14/Feb/24 11:06
• Updated: 14/Feb/24 11:06

Description

STEPS TO REPRODUCE:
Create a ranger hive policy for user u1 to access table t1, view v1 and create&select permission on materialized view mv1.
Create table t1 and add data. Create view v1 and materialized view mv1.
Insert an additional record in t1.
Execute rebuild command on materialized view.
Access is denied as user is not having update permissions on materialized view.
Update ranger policy to provide 'update' access for user on materialized view and wait for policy to be available on hive plugin side.
Execute rebuild command.

CURRENT BEHAVIOUR:
Operation fails with error stating that "Another process is rebuilding the materialized view"