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

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

      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_$.

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

              Created:
              Updated:
              Resolved: