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

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: