Inventory-Gathering Accounts on Oracle Servers

IT Asset Management (Cloud)

The inventory beacon collects inventory from Oracle servers using accounts that must be registered at both ends.

To set up inventory-gathering accounts on an Oracle server:

  1. Open the knowledge base article: https://community.flexera.com/t5/FlexNet-Manager-Knowledge-Base/Script-to-create-an-Oracle-user-with-the-access-required-for/ta-p/1758
  2. Scroll to the bottom of the article, and click the link CreateOracleAuditUserQ200934.sql.
    This downloads a SQL script that an Oracle DBA can review. (Ignore the text content which is for earlier products.)
  3. In a flat text editor, modify lines 8 and 9 of the script, replacing the default user name and password with credentials of your choosing; and save the modified script.
    To minimize configuration and maintenance effort, the same credentials can be implemented on each Oracle Database server. Keep a note of these credentials, as you must also record them in the Password Manager on the inventory beacon.
  4. An Oracle DBA can run the script on each target Oracle Database server.
    This (re)creates the user name on each run, and grants read access to a numbers of tables and views (shown below) that are required for Oracle Database introspection.
The downloaded SQL script gives the account read-only access to the following tables and views:
  • applsys.fnd_app_servers
  • applsys.fnd_nodes
  • applsys.fnd_product_installations
  • applsys.fnd_application_tl
  • applsys.fnd_user
  • applsys.fnd_responsibility
  • apps.fnd_user_resp_groups
  • SYS.DBA_USERS
  • SYS.V_$PARAMETER
  • SYS.V_$INSTANCE
  • SYS.V_$DATABASE
  • SYS.V_$OPTION
  • SYS.DBA_FEATURE_USAGE_STATISTICS
  • SYS.DBA_ENCRYPTED_COLUMNS
  • SYS.DBA_TABLESPACES
  • ODM.ODM_MINING_MODEL
  • ODM.ODM_RECORD
  • DMSYS.DM$OBJECT
  • DMSYS.DM$MODEL
  • DMSYS.DM$P_MODEL
  • DVSYS.DBA_DV_REALM
  • LBACSYS.LBAC$POLT
  • OLAPSYS.DBA$OLAP_CUBES
  • SYS.DBA_AWS
  • SYS.DBA_SEGMENTS
  • SYS.DBA_CUBES
  • SYS.GV_$INSTANCE
  • SYS.GV_$PARAMETER
  • MDSYS.ALL_SDO_GEOM_METADATA
  • SYS.V_$SESSION
  • SYSMAN.MGMT_LICENSE_DEFINITIONS
  • SYSMAN.MGMT_ADMIN_LICENSES
  • SYSMAN.MGMT_LICENSES
  • SYS.DUAL
  • SYSMAN.MGMT_LICENSE_CONFIRMATION
  • SYSMAN.MGMT_TARGETS
  • SYSMAN.MGMT_$TARGET
  • SYSMAN.MGMT_VERSIONS
  • SYSMAN.MGMT_INV_COMPONENT
  • SYSMAN.MGMT_FU_REGISTRATIONS
  • SYSMAN.MGMT_FU_STATISTICS
  • SYSMAN.MGMT_FU_LICENSE_MAP
  • SYS.DBA_REGISTRY
  • SYS.V_$LICENSE
  • SYS.DBA_TABLES
  • CONTENT.ODM_DOCUMENT
  • SYS.V_$VERSION
  • SYS.USER_ROLE_PRIVS
  • SYS.USER_SYS_PRIVS
  • SYS.ROLE_SYS_PRIVS
  • MDSYS.SDO_GEOM_METADATA_TABLE
  • SYS.DBA_INDEXES
  • SYS.DBA_LOBS
  • SYS.DBA_OBJECTS
  • SYS.DBA_RECYCLEBIN
  • SYS.DBA_MINING_MODELS
  • SYS.REGISTRY$HISTORY
  • SYS.DBA_TAB_PARTITIONS
  • SYS.DBA_TAB_SUBPARTITIONS
  • SYS.DBA_LOB_PARTITIONS
  • SYS.DBA_LOB_SUBPARTITIONS
  • SYS.V_$ARCHIVE_DEST_STATUS
  • SYS.DBA_SQL_PROFILES
  • SYS.DBA_ADVISOR_TASKS
  • SYS.DBA_SQLSET
  • SYS.DBA_SQLSET_REFERENCES
  • SYS.DBA_FLASHBACK_ARCHIVE
  • SYS.DBA_FLASHBACK_ARCHIVE_TS
  • SYS.DBA_FLASHBACK_ARCHIVE_TABLES
  • SYS.V_$BLOCK_CHANGE_TRACKING
  • SYS.V_$CONTAINERS

IT Asset Management (Cloud)

Current