[ZBX-20337] Oracle plugin permissions Created: 2021 Dec 09  Updated: 2022 Nov 11  Resolved: 2022 Nov 11

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Templates (T)
Affects Version/s: 5.0.18, 5.4.8, 6.0.0alpha7
Fix Version/s: None

Type: Documentation task Priority: Major
Reporter: Andrew Twemlow Assignee: Zabbix Integration Team
Resolution: Duplicate Votes: 0
Labels: 19c, Oracle, Template
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates ZBX-21296 README.md in source code of oracle pl... Closed
Sub-task
part of ZBX-21296 README.md in source code of oracle pl... Closed

 Description   

When granting the zabbix user permissions to oracle the documented permissions do not work with Oracle 19c, with the below error

Error starting at line 1 in command:
GRANT SELECT ON V$ACTIVE_SESSION_HISTORY TO zabbix
Error report:
SQL Error: ORA-02030: can only select from fixed tables/views
02030. 00000 -  "can only select from fixed tables/views"
*Cause:    An attempt is being made to perform an operation other than
           a retrieval from a fixed table/view.
*Action:   You may only select rows from fixed tables/views.

 

The solution is to change the grant statement, as per the below link

https://dbaclass.com/article/ora-02030-can-only-select-from-fixed-tablesviews/

to the following

GRANT SELECT ON v_$ACTIVE_SESSION_HISTORY TO zabbix;
GRANT SELECT ON v_$ARCHIVE_DEST TO zabbix;
GRANT SELECT ON v_$ASM_DISKGROUP TO zabbix;
GRANT SELECT ON v_$DATABASE TO zabbix;
GRANT SELECT ON v_$DATAFILE TO zabbix;
GRANT SELECT ON v_$INSTANCE TO zabbix;
GRANT SELECT ON v_$LOG TO zabbix;
GRANT SELECT ON v_$OSSTAT TO zabbix;
GRANT SELECT ON v_$PGASTAT TO zabbix;
GRANT SELECT ON v_$PROCESS TO zabbix;
GRANT SELECT ON v_$RECOVERY_FILE_DEST TO zabbix;
GRANT SELECT ON v_$RESTORE_POINT TO zabbix;
GRANT SELECT ON v_$SESSION TO zabbix;
GRANT SELECT ON v_$SGASTAT TO zabbix;
GRANT SELECT ON v_$SYSMETRIC TO zabbix;
GRANT SELECT ON v_$SYSTEM_PARAMETER TO zabbix;

 

Also using the username zabbix instead of zabbix_mon, makes this page consistent with the template default username.



 Comments   
Comment by Edgar Akhmetshin [ 2021 Dec 10 ]

Dynamic performance views are identified by the prefix V_$. Public synonyms for these views have the prefix V$. Database administrators or users should only access the V$ objects, not the V_$ objects. But permissions should be set to V_$ objects or separate views should be created with correct permissions based on the V$ objects.

Oracle 19C:
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/dynamic-performance-views.html#GUID-8C5690B0-DE10-4460-86DF-80111869CF4C

Confirming.

Comment by Aleksandre Sebiskveradze (Inactive) [ 2022 Nov 11 ]

fixed in https://support.zabbix.com/browse/ZBX-21296

Generated at Wed Jul 16 16:51:48 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.