This topic contains the minimum Oracle Database user privileges required for creating a least-privileged user (LPU) for the management pack, as well as a script to help automate its creation.

  • Oracle Database Required Views
  • Creating a Oracle Database Monitoring User

Oracle Database Required Views

The following table lists the views that the management pack will access. As of the time of publishing, these views do not require the Oracle Tuning Pack.

Resource Type View Name Required? Version
Database, Tablespace DBA_DATA_FILES Yes All Supported
Tablespace, Instance DBA_OUTSTANDING_ALERTS Yes All Supported
Tablespace DBA_TABLESPACES Yes All Supported
Database DBA_TEMP_FILES Yes All Supported
Tablespace DBA_TEMP_FREE_SPACE Yes All Supported
Database DBA_UNDO_EXTENTS Yes All Supported
Tablespace DBA_FREE_SPACE Yes All Supported
ALL GLOBAL_NAME Yes All Supported
Instance GV_$ARCHIVE_DEST Yes All Supported
Database, Instance GV_$FILESTAT Yes All Supported
Instance, Query GV_$INSTANCE Yes All Supported
Database, Instance GV_$PARAMETER Yes All Supported
Instance GV_$RESOURCE_LIMIT Yes All Supported
Instance GV_$SESSION Yes All Supported
Instance GV_$SGAINFO Yes All Supported
Query GV_$SQL Yes All Supported
Instance GV_$SYSMETRIC Yes All Supported
Instance GV_$SYSTEM_EVENT Yes All Supported
Instance GV_$SYSTEM_WAIT_CLASS Yes All Supported
Database GV_$TEMPSTAT Yes All Supported
Database V_$ARCHIVE_DEST Yes All Supported
Database V_$CONTROLFILE Yes All Supported
ALL V_$DATABASE Yes All Supported
Database V_$DATAFILE Yes All Supported
Database V_$FILESTAT Yes All Supported
ALL V_$INSTANCE Yes All Supported
Database V_$LOG Yes All Supported
Database V_$LOGFILE Yes All Supported
Database V_$PARAMETER Yes All Supported
Database V_$RECOVERY_AREA_USAGE Yes All Supported
Database V_$RESOURCE_LIMIT Yes All Supported
Database V_$RMAN_BACKUP_JOB_DETAILS Yes All Supported
Database V_$TEMPFILE Yes All Supported
Database V_$VERSION Yes All Supported

Creating a Oracle Database Monitoring User

The following script can be used to help automate the creation of your least-privileged user. It includes the minimum Oracle Database user privileges required for the management pack.

CREATE USER LPU IDENTIFIED BY yourmonitoringpassword;

GRANT CONNECT TO LPU;
GRANT SELECT on gv$instance to LPU;
GRANT SELECT on DBA_DATA_FILES TO LPU;
GRANT SELECT on DBA_FREE_SPACE TO LPU;
GRANT SELECT on DBA_TABLESPACES TO LPU;
GRANT SELECT on DBA_TEMP_FILES TO LPU;
GRANT SELECT on GLOBAL_NAME TO LPU;

GRANT SELECT on GV_$ARCHIVE_DEST TO LPU;
GRANT SELECT on GV_$FILESTAT TO LPU;
GRANT SELECT on GV_$INSTANCE TO LPU;
GRANT SELECT on GV_$PARAMETER TO LPU;
GRANT SELECT on GV_$RESOURCE_LIMIT TO LPU;
GRANT SELECT on GV_$SESSION TO LPU;
GRANT SELECT on GV_$SGAINFO TO LPU;
GRANT SELECT on GV_$SQL TO LPU;
GRANT SELECT on GV_$SYSMETRIC TO LPU;
GRANT SELECT on GV_$SYSTEM_EVENT TO LPU;
GRANT SELECT on GV_$SYSTEM_WAIT_CLASS TO LPU;
GRANT SELECT on GV_$TEMPSTAT TO LPU;
GRANT SELECT on V_$ARCHIVE_DEST TO LPU;
GRANT SELECT on V_$CONTROLFILE TO LPU;
GRANT SELECT on V_$DATABASE TO LPU;
GRANT SELECT on V_$DATAFILE TO LPU;
GRANT SELECT on V_$FILESTAT TO LPU;
GRANT SELECT on V_$INSTANCE TO LPU;
GRANT SELECT on V_$LOG TO LPU;
GRANT SELECT on V_$LOGFILE TO LPU;
GRANT SELECT on V_$PARAMETER TO LPU;
GRANT SELECT on V_$RECOVERY_AREA_USAGE TO LPU;
GRANT SELECT on V_$RESOURCE_LIMIT TO LPU;
GRANT SELECT on V_$RMAN_BACKUP_JOB_DETAILS TO LPU;
GRANT SELECT on V_$TEMPFILE TO LPU;
GRANT SELECT on V_$VERSION TO LPU;
GRANT SELECT on DBA_UNDO_EXTENTS TO LPU;
GRANT SELECT on DBA_UNDO_EXTENTS TO LPU;
GRANT SELECT on DBA_TEMP_FREE_SPACE TO LPU;
GRANT SELECT on DBA_OUTSTANDING_ALERTS TO LPU;