[TIL/ES] Oracle : ORA-01031: insufficient privileges

[TIL/ES] Oracle : ORA-01031: insufficient privileges

 

This is the documented behaviour; from the 19c create view section (emphasis added):

 

The owner of the schema containing the view must have the privileges necessary to either select (READ or SELECT privilege), insert, update, or delete rows from all the tables or views on which the view is based. The owner must be granted these privileges directly, rather than through a role.

 

Role 이 아니라 Privilege로 직접 권한 부여하니까 해결됨