"ORA-02030: can only select from fixed tables/views" in Oracle permissions script (4379230)

When running the Oracle permissions script in the 7.3.2.11 cartridge it tries to grant select privileges improperly on V$ and GV$ views.

Messages like the following result

Error on: GRANT SELECT ON v$session TO C##FOGLIGHT CONTAINER=ALL => ORA-02030: can only select from fixed tables/views
Error on: GRANT SELECT ON gv$archive_dest TO C##FOGLIGHT CONTAINER=ALL => ORA-02030: can only select from fixed tables/views

Oracle doesn't allow you to grant access directly to the V$ views. You must grant access via the SYS schema.

For example, these are being granted: 

GRANT SELECT ON v$session TO C##FOGLIGHT
GRANT SELECT ON gv$archive_dest TO C##FOGLIGHT

if should be like this 

GRANT SELECT ON v_$session TO C##FOGLIGHT
GRANT SELECT ON gv_$archive_dest TO C##FOGLIGHT

WORKAROUND

Please use the attached fixed Oracle permissions script to correctly assign the necessary privileges to system views. The updated script has been adjusted to grant SELECT_CATALOG_ROLE to the user rather than explicitly status the system views.

STATUS

This issue has been logged as defect FOG-11089 and has been fixed in the 8.0 and higher versions of the Oracle cartridge.