Oracle Database

1-- Create the monitoring user "bindplane"
2  CREATE USER bindplane IDENTIFIED BY <authentication password>;
3
4  -- 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;