Error granting SELECT on view that uses ALL_OBJECTS
Yes, use READ privilege (introduced in 12c) instead of SELECT.

SQL&gt; create user MY_OWNER_SCHEMA identified by MY_OWNER_SCHEMA;

User created.

SQL&gt; create user MY_LOGIN_USER identified by MY_LOGIN_USER;

User created.

SQL&gt; grant create session, create view to MY_OWNER_SCHEMA;

Grant succeeded.

SQL&gt; conn MY_OWNER_SCHEMA/MY_OWNER_SCHEMA
Connected.
SQL&gt; CREATE OR REPLACE VIEW OBJECT_COMMENTS AS
SELECT OBJS.OWNER, OBJS.OBJECT_NAME, COMMENTS.COMMENTS
FROM ALL_OBJECTS OBJS
LEFT JOIN ALL_TAB_COMMENTS COMMENTS ON (
    COMMENTS.OWNER = OBJS.OWNER
    AND COMMENTS.TABLE_NAME = OBJS.OBJECT_NAME
)
WHERE
  2    3    4    5    6    7    8    9      OBJS.OWNER = 'MY_OWNER_SCHEMA'
    AND OBJS.OBJECT_TYPE IN ('TABLE', 'VIEW')
WITH READ ONLY
; 10   11   12

View created.

SQL&gt; GRANT SELECT ON OBJECT_COMMENTS TO MY_LOGIN_USER;
GRANT SELECT ON OBJECT_COMMENTS TO MY_LOGIN_USER
                *
ERROR at line 1:
ORA-01720: grant option does not exist for 'SYS.ALL_OBJECTS'


Above fails, but:

SQL&gt; GRANT READ ON OBJECT_COMMENTS TO MY_LOGIN_USER;

Grant succeeded.