Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-20337

Oracle plugin permissions

    XMLWordPrintable

Details

    • Documentation task
    • Status: Confirmed
    • Major
    • Resolution: Unresolved
    • 5.0.18, 5.4.8, 6.0.0alpha7
    • None
    • Documentation (D)

    Description

      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.

      Attachments

        Activity

          People

            zabbix.dev Zabbix Development Team
            twem Andrew Twemlow
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: