Appendix C: Oracle Tables and Views for Oracle Inventory Collection

FlexNet Manager Suite 2020 R1 (On-Premises)
You may need to create a user account to collect Oracle inventory (for details, see the Credentials for... topic for your preferred method of Oracle inventory collection, earlier in this chapter). The database user must have at least read-only access to the following tables and views on each inventoried database instance:
  • ALL_SDO_GEOM_METADATA SELECT
  • DBA_ADVISOR_TASKS SELECT
  • DBA_AUDIT_TRAIL SELECT
  • DBA_AWS SELECT
  • DBA_CPU_USAGE_STATISTICS SELECT
  • DBA_CUBES SELECT
  • DBA_DV_REALM SELECT
  • DBA_ENCRYPTED_COLUMNS SELECT
  • DBA_FEATURE_USAGE_STATISTICS SELECT
  • DBA_FLASHBACK_ARCHIVE_TABLES SELECT
  • DBA_FLASHBACK_ARCHIVE_TS SELECT
  • DBA_FLASHBACK_ARCHIVE SELECT
  • DBA_INDEXES SELECT
  • DBA_LOB_PARTITIONS SELECT
  • DBA_LOB_SUBPARTITIONS SELECT
  • DBA_LOBS SELECT
  • DBA_MINING_MODELS SELECT
  • DBA_OBJECT_TABLES SELECT
  • DBA_OBJECTS SELECT
  • DBA_RECYCLEBIN SELECT
  • DBA_REGISTRY SELECT
  • DBA_SEGMENTS SELECT
  • DBA_SQL_PROFILES SELECT
  • DBA_SQLSET_REFERENCES SELECT
  • DBA_SQLSET SELECT
  • DBA_TAB_PARTITIONS SELECT
  • DBA_TAB_SUBPARTITIONS SELECT
  • DBA_TABLESPACES SELECT
  • DBA_TABLES SELECT
  • DBA_USERS SELECT
  • DUAL SELECT
  • GV_$INSTANCE SELECT
  • GV_$PARAMETER SELECT
  • MGMT$TARGET_PROPERTIES
  • MODEL$ SELECT
  • REGISTRY$HISTORY SELECT
  • ROLE_SYS_PRIVS SELECT
  • SDO_GEOM_METADATA_TABLE SELECT
  • USER_ROLE_PRIVS SELECT
  • USER_SYS_PRIVS SELECT
  • UTL_INADDR EXECUTE
  • V_$ARCHIVE_DEST_STATUS SELECT
  • V_$BLOCK_CHANGE_TRACKING SELECT
  • V_$CONTAINERS SELECT
  • V_$DATABASE SELECT
  • V_$INSTANCE SELECT
  • V_$LICENSE SELECT
  • V_$OPTION SELECT
  • V_$PARAMETER SELECT
  • V_$SESSION SELECT
  • V_$VERSION SELECT

FlexNet Manager Suite (On-Premises)

2020 R1