---
title: Preliminary Steps for SQL Proxy
slug: end-user-guide-3-5-0-legacy-ui/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:

1. Database Addition:
   a.	Accurately add the relevant database to the Kron PAM environment.
2. Property Entry:
   a.	Input properties of this database, including;
   i.	db.name
   ii.	db.username
   iii.	db.password
   iv.	sql.proxy.bind.port
3. User Creation:
   a.	Create a user in Kron PAM with the same username as the one added to the database.
4. Policy Key Creation:
   a.	Formulate a policy key within Kron PAM, ensuring it can dictate user permissions within the SQL proxy (e.g., "White Key Type - Policy Key: “ .\* ")
5. Group and Realm Formation:
   o	Establish groups using the user, device, and policy key, and subsequently create a Realm.

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/ohFuPuQOms_PjsUlcrV8k_image.png "illustrates the panel for adding a device in Kron PAM. ")

:::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.
:::