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.

See also

ORA-00990: missing or invalid privilege
ORA-41900: missing privilege … on …
Other Oracle error messages

Index