My question is what do this sentences when exists the view.
It performs an ALTER VIEW (that don't change the permissions)
Or it performs a DROP and a CREATE (that makes that other users lost his permissions on the view).
1 Answers
create or replace is equivalent to drop and create. (You can refer to this jira - https://issues.apache.org/jira/browse/HIVE-1078).
So, permissions may get reset.
Hive permission on table can be controlled but i am not sure about views. But from my oracle background, i can say there may be problems.
Related