To collect metrics from OracleDB, a user with SELECT access to the relevant views is required. To create a new user with those permissions, run the following SQL script as a user with sufficient permissions connected to the Oracle DB instance as SYSDBA or SYSOPER.
sql
1-- Create the monitoring user "bindplane"
2 CREATE USER bindplane IDENTIFIED BY <authentication password>;
34 -- Grant the "bindplane" user the required permissions
5 GRANT CONNECT TO bindplane;
6 GRANT SELECT ON SYS.GV_$DATABASE to bindplane;
7 GRANT SELECT ON SYS.GV_$INSTANCE to bindplane;
8 GRANT SELECT ON SYS.GV_$PROCESS to bindplane;
9 GRANT SELECT ON SYS.GV_$RESOURCE_LIMIT to bindplane;
10 GRANT SELECT ON SYS.GV_$SYSMETRIC to bindplane;
11 GRANT SELECT ON SYS.GV_$SYSSTAT to bindplane;
12 GRANT SELECT ON SYS.GV_$SYSTEM_EVENT to bindplane;
13 GRANT SELECT ON SYS.V_$RMAN_BACKUP_JOB_DETAILS to bindplane;
14 GRANT SELECT ON SYS.V_$SORT_SEGMENT to bindplane;
15 GRANT SELECT ON SYS.V_$TABLESPACE to bindplane;
16 GRANT SELECT ON SYS.V_$TEMPFILE to bindplane;
17 GRANT SELECT ON SYS.DBA_DATA_FILES to bindplane;
18 GRANT SELECT ON SYS.DBA_FREE_SPACE to bindplane;
19 GRANT SELECT ON SYS.DBA_TABLESPACE_USAGE_METRICS to bindplane;
20 GRANT SELECT ON SYS.DBA_TABLESPACES to bindplane;
21 GRANT SELECT ON SYS.GLOBAL_NAME to bindplane;