Configuring the AlienApp for Oracle Database

Role Availability Read-Only Investigator Analyst Manager

To use the AlienApp for Oracle Database in USM Anywhere, you need to enable the audit trail in Oracle Database and grant audit access to the Oracle Database user account that will be connected to USM Anywhere.

Set Up Oracle Audit Trail

To turn on the audit trail for Oracle Database, refer to the Oracle documentation Enabling or Disabling the Standard Audit Trail.

To grant audit access for the user account

  1. Log into Oracle Database by entering the Oracle Service Identifier (SID) password with the following command:

    sqlplus system/<PASSWORD>@<SID>

  2. Once you have logged in, enable audit access for the user with the following command:

    AUDIT ALL BY <USER> BY ACCESS

Connecting the AlienApp for Oracle Database in USM Anywhere

After obtaining the credentials, you must configure the connection within USM Anywhere.

To enable the AlienApp for Oracle Database

  1. In USM Anywhere, go to Data Sources > AlienApps.
  2. Click the Available Apps tab.
  3. Search for the AlienApp, and then click the tile.
  4. Click Configure API.
  5. If you have more than one deployed USM Anywhere Sensor, select the sensor that you want to use for the enabled AlienApp.

    AlienApps operate through a deployed sensor and use APIs to integrate with the connected third-party technology. Select the sensor that can access the integration endpoint. The HTTPS connections to the API will originate from this sensor, so it is important to make sure the sensor has network access to the AlienApp API endpoints.

  6. Enter your Oracle information into the following fields:

    • Database Host Name
    • Port number
    • Oracle Service Identifier (SID)
    • Username
    • Password
  7. Click Save.
  8. Verify the connection.

    After USM Anywhere completes a successful connection to the Oracle Database APIs, a icon displays in the Health column.

    If the icon displays, there is a problem with the connection. The Message column provides information about the issue. Repeat the steps to fix the configuration or troubleshoot your Oracle Database connection.