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

    • Icon: Documentation task Documentation task
    • Resolution: Duplicate
    • Icon: Trivial Trivial
    • None
    • 6.2.0
    • Agent2 plugin (N)
    • None
    • Team INT

      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.

            esneiders Eriks Sneiders
            stepkh Stepan Khlebalov
            Team INT
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: