> ## Documentation Index
> Fetch the complete documentation index at: https://docs.prequel.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Oracle

> Configuring your Oracle source.

## Prerequisites

* If your Oracle database is protected by security groups or other firewall settings, you will need to have our static IP available to complete Step 1.

<Steps>
  <Step title="Allow access">
    Create a rule in a security group or firewall settings to whitelist:

    * incoming connections to your host and port (usually `1521`) from the static IP.
    * outgoing connections from ports `1024` to `65535` to the static IP.
  </Step>

  <Step title="Create reader user">
    Create a database user to perform the reading of the source data.

    1. Open a connection to your Oracle database.
    2. Create a user for the data transfer by executing the following SQL command.

    ```sql title="Create reader user" icon="database" theme={null}
    CREATE USER <username> IDENTIFIED BY '<some-password>';
    GRANT CREATE SESSION TO <username>;
    ```

    3. Grant user required privileges on the relevant tables.

    ```sql title="Grant table privileges" icon="database" theme={null}
    GRANT SELECT ON 'some_schema'.'some_table' TO <username>;
    ```
  </Step>

  <Step title="Add your source">
    Securely share your **host name**, **database name**, **port**, your chosen **schema name**, **username**, and **password** with us to complete the connection.
  </Step>
</Steps>