OracleDB Connection

Learn how to configure a Oracle Database Connection for Infisical.

OracleDB App Connection is a paid feature.

If you’re using Infisical Cloud, then it is available under the Enterprise Tier. If you’re self-hosting Infisical, then you should contact [e-mail] to purchase an enterprise license to use it.

Infisical supports connecting to OracleDB using a database user.

Configure an Oracle Database User for Infisical

1. Create a User

   Infisical recommends creating a designated user in your Oracle Database for your connection.

   -- create user
   CREATE USER infisical IDENTIFIED BY "my-password";
   
   -- grant create session privileges
   GRANT CREATE SESSION TO infisical;
   

   Username must either be ALL UPPERCASE or not be surrounded by “quotes”. Values not surrounded by quotes get automatically transformed to uppercase by Oracle Database.

2. Grant Relevant Permissions

   Depending on how you intend to use your OracleDB connection, you’ll need to grant one or more of the following permissions.

   To learn more about the Oracle Database permission system, please visit their documentation.

   Secret Rotation

   For Secret Rotations, your Infisical user will require the ability to alter other users’ passwords:

   -- enable permissions to alter login credentials
   GRANT ALTER USER TO infisical;
   

3. Get Connection Details

   You’ll need the following information to create your Oracle Database connection:

   • host - The hostname or IP address of your Oracle Database server
   • port - The port number your Oracle Database server is listening on (default: 1521)
   • database - The Oracle Service Name or SID (System Identifier) for the database you are connecting to. For example: ORCL, FREEPDB1, XEPDB1
   • username - The user name of the login created in the steps above
   • password - The user password of the login created in the steps above
   • sslCertificate (optional) - The SSL certificate required for connection (if configured)

   If you are self-hosting Infisical and intend to connect to an internal/private IP address, be sure to set the ALLOW_INTERNAL_IP_CONNECTIONS environment variable to true.

Create Connection in Infisical

Infisical UI

1. Navigate to the App Connections page in the desired project.

2. Select the OracleDB Connection option.

3. Select the Username & Password method option and provide the details obtained from the previous section and press Connect to OracleDB.

Optionally, if you’d like Infisical to manage the credentials of this connection, you can enable the Platform Managed Credentials option. If enabled, Infisical will update the password of the connection on creation to prevent external access to this database user.

4. Your OracleDB Connection is now available for use.