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

README.md in source code of oracle plugin states a bit wrong commands to grant select on v$ views.

    XMLWordPrintable

Details

    • Team INT
    • Sprint 94 (Nov 2022), Sprint 95 (Dec 2022)
    • 1

    Description

      Steps to reproduce:

      1. Oracle Database 12c Enterprise Edition Release 12.2.0.1.0SQL> GRANT SELECT ON V$ACTIVE_SESSION_HISTORY TO zabbix_mon
                        *
        ERROR at line 1:
        ORA-02030: can only select from fixed tables/views (Oracle Database 12c Enterprise Edition Release 12.2.0.1.0)

      Result:
      ORA-02030
      Expected:
      Grant succeeded.

       

      The way to fix is substitute v$ with v_$.

      Attachments

        Issue Links

          depends on

          Problem report - Problem report ZBX-20202 templates for Oracle monitoring need updates to support v 12.2.0.1

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Problem report - Problem report ZBX-20052 Zabbix-agent2 Plugin permissons are not enough

          • Major - Major loss of function.
          • Closed

          Documentation task - Documentation task ZBX-20337 Oracle plugin permissions

          • Major - Major loss of function.
          • Closed

          Documentation task - Documentation task ZBX-21316 grant select on v_$restore_point is not enough to select from this view.

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed
          is duplicated by

          Documentation task - Documentation task ZBX-20337 Oracle plugin permissions

          • Major - Major loss of function.
          • Closed

          Activity

            People

              knaglis Kristaps Naglis
              stepkh Stepan Khlebalov
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: