-
Documentation task
-
Resolution: Duplicate
-
Major
-
None
-
5.0.18, 5.4.8, 6.0.0alpha7
When granting the zabbix user permissions to oracle the documented permissions do not work with Oracle 19c, with the below error
Error starting at line 1 in command:
GRANT SELECT ON V$ACTIVE_SESSION_HISTORY TO zabbix
Error report:
SQL Error: ORA-02030: can only select from fixed tables/views
02030. 00000 - "can only select from fixed tables/views"
*Cause: An attempt is being made to perform an operation other than
a retrieval from a fixed table/view.
*Action: You may only select rows from fixed tables/views.
The solution is to change the grant statement, as per the below link
https://dbaclass.com/article/ora-02030-can-only-select-from-fixed-tablesviews/
to the following
GRANT SELECT ON v_$ACTIVE_SESSION_HISTORY TO zabbix;
GRANT SELECT ON v_$ARCHIVE_DEST TO zabbix;
GRANT SELECT ON v_$ASM_DISKGROUP TO zabbix;
GRANT SELECT ON v_$DATABASE TO zabbix;
GRANT SELECT ON v_$DATAFILE TO zabbix;
GRANT SELECT ON v_$INSTANCE TO zabbix;
GRANT SELECT ON v_$LOG TO zabbix;
GRANT SELECT ON v_$OSSTAT TO zabbix;
GRANT SELECT ON v_$PGASTAT TO zabbix;
GRANT SELECT ON v_$PROCESS TO zabbix;
GRANT SELECT ON v_$RECOVERY_FILE_DEST TO zabbix;
GRANT SELECT ON v_$RESTORE_POINT TO zabbix;
GRANT SELECT ON v_$SESSION TO zabbix;
GRANT SELECT ON v_$SGASTAT TO zabbix;
GRANT SELECT ON v_$SYSMETRIC TO zabbix;
GRANT SELECT ON v_$SYSTEM_PARAMETER TO zabbix;
Also using the username zabbix instead of zabbix_mon, makes this page consistent with the template default username.