---
title: Preliminary Steps for SQL Proxy
slug: kron-pam-end-user-guide-3-6-0/preliminary-steps-for-sql-proxy
description: Learn how to connect to an Oracle database with this detailed step-by-step guide. Follow the instructions to create a new connection on a SQL client, enter your database credentials, and set the connection host and port. Ensure that your username and pass
docTags: 
createdAt: 2022-08-10T14:57:04.000Z
---

Before utilizing SQL Proxy for database connection, adhere to the following preliminary steps:

- **Database Addition:**
  a.	Accurately add the relevant database to the Kron PAM environment.
- **Property Entry:**
  a.	Input properties of this database, including;
  - **db.name
**
  - **db.username
**
  - **db.password**

- **User Creation:**
  - Create a user in Kron PAM with the same username as the one added to the database.
- **Policy Key Creation:**
  - Formulate a policy key within Kron PAM, ensuring it can dictate user permissions within the SQL proxy (e.g., "White Key Type - Policy Key: “ .\* ")
- **Group and Realm Formation:**
  - Establish groups using the user, device, and policy key, and subsequently create a Realm.

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/ptLvW4BDrrJ3ptVgqDz-Q_image.png "illustrates the panel for adding db.name, db.username and db.password in Kron PAM.")

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/RaJ9zuoBcmP9eTOBrk96W_image.png "SQL Proxy Bind Port for connection")

:::hint{type="info"}
The username and password are the same as the user credentials used to directly connect to the database. The username must be defined as a user in Kron PAM, and realms must be created for connection and policy enforcement by a system Admin.
:::