Create a user for Collection

The collection scripts can be executed with any DBA account. Alternatively, create a new user with the minimum privileges required. The included script sql/setup/grants_wrapper.sql will grant the privileges listed below. Please see the Database User Scripts page for information on how to create the user.

Permissions Required

The following permissions are required for the script execution:

  SELECT ON SYS.CDB_HIST_ACTIVE_SESS_HISTORY
  SELECT ON SYS.CDB_HIST_OSSTAT
  SELECT ON SYS.CDB_HIST_SNAPSHOT
  SELECT ON SYS.CDB_HIST_SQLSTAT
  SELECT ON SYS.CDB_HIST_SQLTEXT
  SELECT ON SYS.CDB_HIST_SYSMETRIC_HISTORY
  SELECT ON SYS.CDB_HIST_SYSMETRIC_SUMMARY
  SELECT ON SYS.CDB_HIST_SYSSTAT
  SELECT ON SYS.CDB_HIST_SYSTEM_EVENT
  SELECT ON SYS.CDB_HIST_SYS_TIME_MODEL
  SELECT ON SYS.DBA_HIST_ACTIVE_SESS_HISTORY
  SELECT ON SYS.DBA_HIST_OSSTAT
  SELECT ON SYS.DBA_HIST_SNAPSHOT
  SELECT ON SYS.DBA_HIST_SQLSTAT
  SELECT ON SYS.DBA_HIST_SQLTEXT
  SELECT ON SYS.DBA_HIST_SYSMETRIC_HISTORY
  SELECT ON SYS.DBA_HIST_SYSMETRIC_SUMMARY
  SELECT ON SYS.DBA_HIST_SYSSTAT
  SELECT ON SYS.DBA_HIST_SYSTEM_EVENT
  SELECT ON SYS.DBA_HIST_SYS_TIME_MODEL
  EXECUTE ON SYS.DBMS_UMF
  EXECUTE ON SYS.DBMS_QOPATCH
  SELECT ON PERFSTAT.STATS$OSSTATNAME
  SELECT ON PERFSTAT.STATS$OSSTAT
  SELECT ON PERFSTAT.STATS$SNAPSHOT
  SELECT ON PERFSTAT.STATS$SQL_SUMMARY
  SELECT ON PERFSTAT.STATS$SYSSTAT
  SELECT ON PERFSTAT.STATS$SYSTEM_EVENT
  SELECT ON PERFSTAT.STATS$SYS_TIME_MODEL
  SELECT ON PERFSTAT.STATS$TIME_MODEL_STATNAME
  SELECT ON SYS.AUX_STATS$
  SELECT ON SYS.CDB_CONSTRAINTS
  SELECT ON SYS.CDB_CPU_USAGE_STATISTICS
  SELECT ON SYS.CDB_DATA_FILES
  SELECT ON SYS.CDB_DB_LINKS
  SELECT ON SYS.CDB_EXTERNAL_TABLES
  SELECT ON SYS.CDB_FEATURE_USAGE_STATISTICS
  SELECT ON SYS.CDB_FREE_SPACE
  SELECT ON SYS.CDB_HIGH_WATER_MARK_STATISTICS
  SELECT ON SYS.CDB_INDEXES
  SELECT ON SYS.CDB_LOB_PARTITIONS
  SELECT ON SYS.CDB_LOBS
  SELECT ON SYS.CDB_LOB_SUBPARTITIONS
  SELECT ON SYS.CDB_MVIEWS
  SELECT ON SYS.CDB_OBJECTS
  SELECT ON SYS.CDB_OBJECT_TABLES
  SELECT ON SYS.CDB_PART_TABLES
  SELECT ON SYS.CDB_PDBS
  SELECT ON SYS.CDB_SEGMENTS
  SELECT ON SYS.CDB_SERVICES
  SELECT ON SYS.CDB_SOURCE
  SELECT ON SYS.CDB_SYNONYMS
  SELECT ON SYS.CDB_TAB_COLS
  SELECT ON SYS.CDB_TAB_COLUMNS
  SELECT ON SYS.CDB_TABLESPACES
  SELECT ON SYS.CDB_TABLES
  SELECT ON SYS.CDB_TAB_PARTITIONS
  SELECT ON SYS.CDB_TAB_SUBPARTITIONS
  SELECT ON SYS.CDB_TEMP_FILES
  SELECT ON SYS.CDB_TRIGGERS
  SELECT ON SYS.CDB_USERS
  SELECT ON SYS.CDB_VIEWS
  SELECT ON SYS.CDB_XML_TABLES
  SELECT ON SYS.CONTAINER$
  SELECT ON SYS.DBA_CONSTRAINTS
  SELECT ON SYS.DBA_CPU_USAGE_STATISTICS
  SELECT ON SYS.DBA_DATA_FILES
  SELECT ON SYS.DBA_DB_LINKS
  SELECT ON SYS.DBA_EXTERNAL_TABLES
  SELECT ON SYS.DBA_FEATURE_USAGE_STATISTICS
  SELECT ON SYS.DBA_FREE_SPACE
  SELECT ON SYS.DBA_HIGH_WATER_MARK_STATISTICS
  SELECT ON SYS.DBA_INDEXES
  SELECT ON SYS.DBA_LOB_PARTITIONS
  SELECT ON SYS.DBA_LOBS
  SELECT ON SYS.DBA_LOB_SUBPARTITIONS
  SELECT ON SYS.DBA_MVIEWS
  SELECT ON SYS.DBA_OBJECTS
  SELECT ON SYS.DBA_OBJECT_TABLES
  SELECT ON SYS.DBA_PART_TABLES
  SELECT ON SYS.DBA_REGISTRY_SQLPATCH
  SELECT ON SYS.DBA_SEGMENTS
  SELECT ON SYS.DBA_SERVICES
  SELECT ON SYS.DBA_SOURCE
  SELECT ON SYS.DBA_SYNONYMS
  SELECT ON SYS.DBA_TAB_COLS
  SELECT ON SYS.DBA_TAB_COLUMNS
  SELECT ON SYS.DBA_TABLESPACES
  SELECT ON SYS.DBA_TABLES
  SELECT ON SYS.DBA_TAB_PARTITIONS
  SELECT ON SYS.DBA_TAB_SUBPARTITIONS
  SELECT ON SYS.DBA_TEMP_FILES
  SELECT ON SYS.DBA_TRIGGERS
  SELECT ON SYS.DBA_USERS
  SELECT ON SYS.DBA_VIEWS
  SELECT ON SYS.DBA_XML_TABLES
  SELECT ON SYS.GV_$ARCHIVE_DEST
  SELECT ON SYS.GV_$ARCHIVED_LOG
  SELECT ON SYS.GV_$DATABASE
  SELECT ON SYS.GV_$INSTANCE
  SELECT ON SYS.GV_$PARAMETER
  SELECT ON SYS.GV_$PDBS
  SELECT ON SYS.GV_$PGASTAT
  SELECT ON SYS.GV_$PROCESS
  SELECT ON SYS.GV_$SGASTAT
  SELECT ON SYS.GV_$SYSTEM_PARAMETER
  SELECT ON SYS.NLS_DATABASE_PARAMETERS
  SELECT ON SYS.OBJ$
  SELECT ON SYS.REGISTRY$HISTORY
  SELECT ON SYS.V_$ARCHIVE_DEST
  SELECT ON SYS.V_$DATABASE
  SELECT ON SYS.V_$EVENT_NAME
  SELECT ON SYS.V_$INSTANCE
  SELECT ON SYS.V_$LOGFILE
  SELECT ON SYS.V_$LOG_HISTORY
  SELECT ON SYS.V_$LOG
  SELECT ON SYS.V_$PARAMETER
  SELECT ON SYS.V_$PDBS
  SELECT ON SYS.V_$PGASTAT
  SELECT ON SYS.V_$RMAN_BACKUP_JOB_DETAILS
  SELECT ON SYS.V_$SGASTAT
  SELECT ON SYS.V_$SQLCOMMAND
  SELECT ON SYS.V_$SYSTEM_PARAMETER
  SELECT ON SYS.V_$TEMP_SPACE_HEADER
  SELECT ON SYS.V_$VERSION
  SELECT ON SYSTEM.LOGSTDBY$SKIP_SUPPORT