User for Oracle Database monitoring via Zabbix

create_oracle_monitor_user.sql

CREATE USER ZABBIXMON IDENTIFIED BY "zabbixmon" DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT CONNECT TO ZABBIXMON;
GRANT RESOURCE TO ZABBIXMON;
ALTER USER ZABBIXMON DEFAULT ROLE ALL;
GRANT SELECT ANY TABLE TO ZABBIXMON;
GRANT CREATE SESSION TO ZABBIXMON;
GRANT SELECT ANY DICTIONARY TO ZABBIXMON;
GRANT UNLIMITED TABLESPACE TO ZABBIXMON;
GRANT SELECT ANY DICTIONARY TO ZABBIXMON;
GRANT SELECT ON V_$SESSION TO ZABBIXMON;
GRANT SELECT ON V_$SYSTEM_EVENT TO ZABBIXMON;
GRANT SELECT ON V_$EVENT_NAME TO ZABBIXMON;
GRANT SELECT ON V_$RECOVERY_FILE_DEST TO ZABBIXMON;
GRANT SELECT ON V_$ARCHIVED_LOG TO ZABBIXMON;
GRANT SELECT ON V_$DATABASE TO ZABBIXMON;
GRANT SELECT ON V_$INSTANCE TO ZABBIXMON;
GRANT SELECT ON V_$ARCHIVE_GAP TO ZABBIXMON;
GRANT SELECT ON V_$MANAGED_STANDBY TO ZABBIXMON;