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

    • Documentation task
    • Status: Confirmed
    • Trivial
    • Resolution: Unresolved
    • 6.0.6
    • None
    • Agent2 plugin (N)
    • None

    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

          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.
          • Confirmed

          Activity

            People

              zit Zabbix Integration Team
              stepkh Stepan Khlebalov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: