Details
-
Documentation task
-
Status: Closed
-
Trivial
-
Resolution: Fixed
-
6.0.6
-
None
-
Team INT
-
Sprint 94 (Nov 2022), Sprint 95 (Dec 2022)
-
1
Description
Steps to reproduce:
- 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
-
ZBX-20052 Zabbix-agent2 Plugin permissons are not enough
-
- Closed
-
-
ZBX-20337 Oracle plugin permissions
-
- Closed
-
-
ZBX-20202 templates for Oracle monitoring need updates to support v 12.2.0.1
-
- Closed
-
-
ZBX-21316 grant select on v_$restore_point is not enough to select from this view.
-
- Closed
-
- is duplicated by
-
ZBX-20337 Oracle plugin permissions
-
- Closed
-