[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: |
|
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:
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;
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. Confirming. |
Comment by Aleksandre Sebiskveradze (Inactive) [ 2022 Nov 11 ] |