[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 ] |