End User Guide
...
SQL Proxy
Establishing a Connection via Kron PAM SQL Proxy
1 min
The port number is the identifier of the connection to the Database via Kron PAM SQL Proxy.
To establish a connection using SQL Proxy:
- Utilize an SQL client (such as DBeaver, DataGrip, SQL Workbench, etc.)
- Initiate a new connection in the SQL client, selecting the type of database added to Kron PAM (e.g., if Oracle was added to Kron PAM, select an Oracle-type connection).
- Enter the username and password for the device you entered in Kron PAM into the connection screen of your SQL client.
- Enter the SQL proxy port number, specifically assigned in Kron PAM, into the PORT field.
- Input the IP number of Kron PAM into the Host field.
- Enter the database name you entered in Kron PAM into the Service Name field.
- Establish the connection.
Demonstrates the screen for connecting via an SQL client
- The username and password are the same as the user credentials used directly 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.