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