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

grant select on v_$restore_point is not enough to select from this view.

    XMLWordPrintable

Details

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

    Description

      As an extent to https://support.zabbix.com/browse/ZBX-21296

      Steps to reproduce:

      1. grant select on v_$restore_point to zabbix_mon; (as sysdba)
      2. describe v$restore_point; (as zabbix_mon to see the fact that previous was successful)
      3. select name from v$restore_point; (as zabbix_mon)

      Result:
      ERROR at line 1:
      ORA-01031: insufficient privileges

      Also you can see the same in zabbix-agent2.log as "2022/07/08 16:10:19.870563 [Oracle] Cannot fetch data: dpiStmt_execute: ORA-01031: insufficient privileges."

      Made screenshot of dashboard "Latest data" which is correlated to this error.


      Expected:
      Successuful select, no error in dashboard, no error in agent log.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated: