Search notes:
ORA-41904: Missing object privilege on … to create a view.
User RENE tries to create view and gets the error message ORA-41904: Missing object privilege on "SYS"."DBA_TAB_COMMENTS" to create a view.:
create view tq84_x as
select *
from
dba_tab_comments;
Someone with better privileges helps:
grant select on dba_tab_comments to rene;
Now, the view can be created by RENE.
Granting select on all dictionary views
grant select any dictionary to rene;