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

XMLWordPrintable

    • Type: Documentation task
    • Resolution: Duplicate
    • Priority: Trivial
    • None
    • Affects Version/s: 6.2.0
    • Component/s: Agent2 plugin (G)
    • None

      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.

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

              Created:
              Updated:
              Resolved: