ORA-01720 when GRANT SELECT ON custom view including sys.-view since Oracle 12.2 or higher (solved)

Hello Experts,

we are using a custom view to get data from sys.user_tab_comments amongst other things.

Here an simplified example

CREATE OR REPLACE VIEW view_comments ( table_name, comments )as SELECT table_name, comments FROM sys.user_tab_comments;GRANT SELECT ON view_comments TO user_role;

This works fine with ORACLE versions 11.2  and 12.1.

But fails with ORACLE versions 12.2 and 18.3 giving the following error.

GRANT SELECT ON view_comments TO user_role

Fehlerbericht -

SQL-Fehler: ORA-01720: Berechtigungsoption für 'SYS.USER_TAB_COMMENTS' nicht vorhanden

1. 00000 -  "grant option does not exist for '%s.%s'"

*Cause:    A grant was being performed on a view or a view was being replaced