Reference Guide
...
User/Device/Policy Definition
Adding a Database as a Device
5 min
This section shows how to add one database to the KRON PAM.
Prerequired Configuration: The port number is the identifier of the connection to ORACLE, MSSQL, MySQL and Cassandra, Teradata, Hive, PostgreSQL, and DB2 via a Kron PAM SQL Proxy. The port number must be defined in the Device Properties of the MSSQL, MySQL Cassandra, Teradata, Hive, PostgreSQL, DB2, SAP Hana, and Couchbase databases.
The following system configuration parameter should be set for the port assignment option:
- Navigate to Administration > System Config Manager.
- Click the blue Add button and inside the pop-up select the Add New System Parameter button.
- Set the sql.proxy.bind.port.range parameter with the requested port range.
Parameter Name | Parameter Value |
|---|---|
sql.proxy.bind.port.range | Port range (e.g. 1000-2000) |
SQL Proxy Bind Port

The target database is configured as a device:
- Navigate to Devices > Inventory.
- Click the blue Add button and inside the pop-up select the Add Device button.
- Information, Enter the following required information: a. IP address b. Device Name c. Port (if not set, the default port is used according to the access protocol) d. Access protocol (Oracle TNS, MSSQL, PostgreSQL etc.). When you select Access protocol the following inputs will appear: i. Database Name ii. Username of Database User (this must match with the created User’s username) iii. Password of Database User e. Element Type
Database Device Addition / Information Section

- Group Membership, enter your device group.
Database Device Addition / Group Membership Section

- Properties, click the Auto Assign (This will use the setup parameter of the system configuration manager guided earlier)
Database Device Addition / SQL PROXY Bind Port in Properties Section

- Click the Test Connection button to control the connection information you provided.
