oracle_grants.sql

For all Oracle version:
CREATE PROFILE ZABBIXMON_UNLIMITED_PWD LIMIT PASSWORD_LIFE_TIME UNLIMITED;

For all Oracle version:
CREATE USER zabbixmon IDENTIFIED BY "XXXXXXX" DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE TEMP PROFILE ZABBIXMON_UNLIMITED_PWD ACCOUNT UNLOCK;
ALTER USER zabbixmon DEFAULT ROLE ALL;
GRANT CONNECT TO zabbixmon;
GRANT RESOURCE TO zabbixmon;
GRANT CREATE SESSION TO zabbixmon;
GRANT SELECT ANY DICTIONARY TO zabbixmon;
GRANT UNLIMITED TABLESPACE 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;
GRANT SELECT ON V_$FLASH_RECOVERY_AREA_USAGE TO zabbixmon;
GRANT SELECT ON V_$DATABASE_INCARNATION TO zabbixmon;
GRANT SELECT ON V_$ARCHIVE_DEST_STATUS TO zabbixmon;
GRANT SELECT ON V_$RESOURCE_LIMIT TO zabbixmon;
GRANT SELECT ON V_$BACKUP TO zabbixmon;
GRANT SELECT ON V_$DATAFILE TO zabbixmon;
GRANT SELECT ON V_$DBFILE TO zabbixmon;
GRANT SELECT ON V_$PARAMETER TO zabbixmon;
GRANT SELECT ON V_$PROCESS TO zabbixmon;
GRANT SELECT ON V_$SESSION_WAIT TO zabbixmon;
GRANT SELECT ON GV_$INSTANCE TO zabbixmon;
GRANT SELECT ON GV_$SESSION TO zabbixmon;

If monitoring Oracle ASM:
GRANT SELECT ON V_$ASM_DISKGROUP_STAT TO zabbixmon;

If rdbms_version>=12
GRANT SELECT ON CDB_TABLESPACES TO zabbixmon;
GRANT SELECT ON CDB_TABLESPACE_USAGE_METRICS TO zabbixmon;
GRANT SELECT ON CDB_DATA_FILES TO zabbixmon;
GRANT SELECT ON DBA_PDBS TO zabbixmon;
GRANT SELECT ON V_$PDBS TO zabbixmon;
GRANT SELECT ON V_$PDB_INCARNATION TO zabbixmon;
GRANT SELECT ON V_$CONTAINERS TO zabbixmon;

If monitoring Oracle Data Guard:
GRANT SYSDBA TO zabbixmon;

If monitoring Oracle ASM connect to Oracle ASM instance and create user:
CREATE USER zabbixmon IDENTIFIED BY "XXXXXXX";
GRANT SYSASM TO zabbixmon;