Details
-
Documentation task
-
Status: Confirmed
-
Trivial
-
Resolution: Unresolved
-
6.0.6
-
None
-
None
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-21316 grant select on v_$restore_point is not enough to select from this view.
-
- Confirmed
-